News for hackers. Stuff that matters.
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?
Re:Features I'd Like in PostgreSQL by srcreigh on Sunday January 29, 2023 @06:19AM (#34567073)
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.