News for hackers. Stuff that matters.
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.