Peter Geoghegan on Twitter: "@coutu_benjamin @planetpostgres I'm familiar with Bw-Trees. I'm skeptical of latch-free data structures, at least when it comes to general purpose RDBMSs, where being a good performance all-rounder matters most. Also relevant: https://t.co/OxF4u3VEFo" / Twitter

Laurenz Albe: Index bloat reduced in PostgreSQL v14

Index bloat reduced in PostgreSQL v14 - CYBERTEC

This article describes how PostgreSQL v14 reduces B-tree index bloat with "bottom-up index tuple deletion". A test case shows the difference.

1

8

22

Replying to

and

Just discovered this recent publication about latch-free Bw-trees, which might interest you: microsoft.com/en-us/research

1

Replying to

and

I'm familiar with Bw-Trees. I'm skeptical of latch-free data structures, at least when it comes to general purpose RDBMSs, where being a good performance all-rounder matters most. Also relevant: db.cs.cmu.edu/papers/2018/mo

6:13 PM · Nov 10, 2021Twitter Web App

1

Like

Conversation