4 ms·
Surprised this doesn't mention Materialized Views. Those can be used to create the buckets/facets from the larger table then offer faster lookup of the facet v
by djbusby 4y ago
Surprised this doesn't mention Materialized Views. Those can be used to create the buckets/facets from the larger table then offer faster lookup of the facet values.
Creating the MView would still be from a sequential scan but then you'll have small/fast views to queue queries for the huge table.
- jaxn 4y agoAnd you have some control over when that scan happens, as well as the ability to index the MV