4 ms·
I don’t think the visibility map suffers from bloat. It’s a bitmap with 1 bit per page. You might have more pages due to the extra size of each tuple, but it’s
by aidos 2y ago
I don’t think the visibility map suffers from bloat. It’s a bitmap with 1 bit per page.
You might have more pages due to the extra size of each tuple, but it’s not likely to be a big difference.
- 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-...