Skip to content

Glossary: PostgreSQL Beyond the Basics

BRIN

Also written: block range index

A very small index that stores only the lowest and highest value for each range of table pages. It works when the column's order matches the table's physical order, like event times in `events`.

Where the book teaches it

Related terms

LossyB-tree