On Thu, 2021-04-01 at 21:28 -0500, Merlin Moncure wrote: > I would never use UUIDS for keys though.
That makes me curious for your reasons. I see the following disadvantages: - A UUID requires twice as much storage space as a bigint. - B-tree indexes are space optimized for inserting at the rightmost leaf page, but UUIDs are random. - UUIDs are more expensive to generate. On the other hand, many processes trying to insert into the same index page might lead to contention. Is there anything I have missed? Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
