News for hackers. Stuff that matters.

A comment on PostgreSQL and UUID as Primary Key. Parent comment

Re:PostgreSQL and UUID as Primary Key by sgarland on Saturday July 06, 2024 @09:48AM (#40890454)
It’s orthogonal, and also technically incorrect – the row overhead itself is indeed 23 bytes (less NULL bitmap), but it gets aligned to 24 bytes. Run pg_column_size(ROW()) if you’d like to check.

The fact that this overhead exists has nothing to do with the 8.6 GB of wasted space on the INTs.

[ Parent | on HN ]
Re:PostgreSQL and UUID as Primary Key by riku_iki on Saturday July 06, 2024 @11:42AM (#40891084)
> It’s orthogonal

I disagree its orthogonal and explained why. I guess lets agree on disagree.

[ Parent | on HN ]