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