So early benchmarks of #PostgreSQL 12 promise 40% reduction in size for B-Tree indexes with lots of updates... I already have some indexes in mind to test this with. Let's wait and see.
info.crunchydata.com/blog/just-upgr
Conversation
Replying to
40% is on the high side -- that's what you'll see if you have this specific insertion pattern: youtu.be/p5RaATILoiE?t=. Please let me know how your test case is affected by the v12 changes (I am the author).
Replying to
Thanks for the reference, IIUC composite indexes are most likely to benefit from this change?
1