Block Range Index (BRIN)

An index type designed for handling very large tables in which certain columns have some natural correlation with their physical location within the table

A Block Range Index (BRIN) is an index type designed for handling very large tables in which certain columns have some natural correlation with their physical location within the table.

Support for BRIN indexes was added in PostgreSQL 9.5.

Change history

Categories

Indexing, Storage

See also

brin (test module)