Moment at 7:26 in I replaced my entire stack with Postgres... by The Coding Gopher.
For massive log volumes, **Block Range Indexes (BRIN)** store min/max timestamps for physical disk blocks, allowing the engine to skip millions of irrelevant rows during time-range queries.
Saved by George Vanous 🌱.