Re:Features I'd Like in PostgreSQL
by avinassh on Sunday January 29, 2023 @12:06AM
(#34565137)
How would one measure the B Tree bloat in Postgres?
[ Parent
| on HN ]
B-trees are self balancing so I don't think there will be bloat. But if you insert towards the end of an index a lot, the right-side of the index will more likely be in cache which makes it a lot faster. If you inserted randomly then you need to do lots of traversals in different parts of the B-Tree.