Features I'd Like in PostgreSQL

Re:Features I'd Like in PostgreSQL by jeltz on Saturday January 28, 2023 @08:14PM (#34563876)

Also more btree index bloat and slower inserts due to random insert order.

[ Parent | on HN ]

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 ]

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.

[ Parent | on HN ]