PostgreSQL 13 B-Trees will be able to use deduplication, which I committed today. It often make indexes far smaller. Also helps VACUUM with controlling index bloat (even in unique indexes). I wrote some documentations on the internals, for advanced users: postgresql.org/docs/devel/btr
Conversation
This Tweet was deleted by the Tweet author. Learn more
Thanks! I don't know much about MLS. Still, I can't imagine a way in which deduplication would make MLS any harder. The deduplication design is fundamentally based on the idea that we never change the logical/observable contents of the index. It's entirely a storage level thing.