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.
I call BS.