We've finally upgraded to PostgreSQL 12, and the new BTree index mechanism provides pretty unexpected results. It's much more compact now than the hash index, at least for a column with lots of duplicates. New btree is 25 GB, new hash index is 38 GB (billion+ rows).
Conversation
Replying to
I'm the author of that feature. What was it like before you upgraded?