PostgreSQL Indexing: When BRIN Is a Better Choice Than B-Tree

If you’re indexing huge, append-only tables with naturally ordered data — BRIN can give you massive performance and space benefits compared to B-Tree. What is a BRIN Index? BRIN = Block Range Index A BRIN index doesn't index every row, unlike B-Tree....