News for hackers. Stuff that matters.
Re:PostgreSQL and UUID as Primary Key by paulddraper on Friday July 05, 2024 @05:43PM (#40886296)
I haven't maintained any sizable database system without any issues, least of all performance ones.

I call BS.

Re:PostgreSQL and UUID as Primary Key by netcraft on Friday July 05, 2024 @07:20PM (#40886937)
lol, I of course don't mean that I have no issues, performance or otherwise. Only that I have never had an issue with UUIDs in postgres
Re:PostgreSQL and UUID as Primary Key by paulddraper on Friday July 05, 2024 @09:09PM (#40887456)
The "issue" is that you're doubling the size of your identifiers, and increasing memory usage of indexes.

And memory is the key factor of any sizable database.

Re:PostgreSQL and UUID as Primary Key by tomnipotent on Friday July 05, 2024 @06:24PM (#40886595)
This gave me a good chuckle, and has generally been my experience. Systems grow often in unpredictable or unintuitive ways.

You can pay the cost for something upfront, and the cost of maintaining it, and in the long term paid too much for something you didn't actually need.

Alternatively you can wait to pay it until you're certain you need it but the work involved has become much more significant, in which it can cost more than it would have to have built and maintained it from the beginning.

Compounding the issue is the build-up-front scenario costs fade with time and you don't really think about them, but build-when-you-need-it always creates a stir even if the costs are less overall than build-up-front.

Either way something will go wrong no matter how many times you predict where the cards will fall.