2 ms·
> 1 bit per page Close, it’s 2 bits/page :-) It’s not that it bloats, it’s that the hits are scattered among many pages. My wording wasn’t great on that point
by sgarland 2y ago
> 1 bit per page
Close, it’s 2 bits/page :-)
It’s not that it bloats, it’s that the hits are scattered among many pages. My wording wasn’t great on that point.
Some tests demonstrating this are here [0].
[0]: https://www.cybertec-postgresql.com/en/unexpected-downsides-of-uuid-keys-in-postgresql/ https://www.cybertec-postgresql.com/en/unexpected-downsides-...