CREATE INDEX ON events USING BRIN (created_at) WITH (pages_per_range = 4);
SELECT * FROM events WHERE created_at BETWEEN 'Mar-15' AND 'Apr-05';
Heap (32 pages) — each block holds rows with a date
Rows are loosely time-ordered (events arrive chronologically). Blocks are grouped into ranges of 4 pages.
BRIN summary (one entry per range — very small)