Postgres Indexing: When Does Brin Win?(crunchydata.com) |
Postgres Indexing: When Does Brin Win?(crunchydata.com) |
"Chapter 71. BRIN Indexes"[0]
> BRIN stands for Block Range Index. BRIN is designed for handling very large tables in which certain columns have some natural correlation with their physical location within the table.