Re:BRIN Indexes in Postgres 9.5
by ddebernardy on Friday September 16, 2016 @05:08PM
(#12517363)
You can probably pre-compute part or all of those aggregates using triggers, and then run those queries in ~200ms or less with a plain B-tree.
[ Parent
| on HN ]
Yeah, that's what we did in the part we said "Pretend this is where we stopped" :) We pre-computed a few major dimensions and choose which table to query based on which columns are being requested. BRIN indexes were still a win vs B-tree, though.
We keep being impressed by Postgres--we keep being able to flog it harder and harder instead of moving to something heavier duty.