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`.