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.
But wouldn’t that require a index on it if it’s going to be an identifier that’s used to query?