News for hackers. Stuff that matters.
Re:How to Get the Most Out of Postgres Memory Settings by moomoo11 on Wednesday June 12, 2024 @02:28PM (#40661275)
Quick question. So you’re saying use bigserial for PK (instead of uuid) and have another column where I set a uuid in case of application level identifier.

But wouldn’t that require a index on it if it’s going to be an identifier that’s used to query?

Re:How to Get the Most Out of Postgres Memory Settings by VWWHFSfQ on Wednesday June 12, 2024 @03:48PM (#40662230)
Yes but you only have a single index containing the UUIDs instead of duplicated everywhere that is using it as a foreign key relation. Those indexes quickly become explosive in relations like e.g. m2m tables.
Re:How to Get the Most Out of Postgres Memory Settings by hot_gril on Wednesday June 12, 2024 @08:14PM (#40664581)
This, plus for translating between client-visible UUIDs and database-internal bigserials, you can use a cache if you're really concerned about read performance.