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).
1
1
Replying to
Thanks for the reference, IIUC composite indexes are most likely to benefit from this change?
1
Replying to
Composite indexes and low cardinality indexes are most affected