3 ms·

I'd love to use materialised views more often but my experience is that they're full of annoying limitations, typically around functions that feel like they sho

by remus 4y ago

I'd love to use materialised views more often but my experience is that they're full of annoying limitations, typically around functions that feel like they should be immutable but aren't.

kiernanmcgowan 4y ago
Right, I think the timestamp with timezone type is a great example of one of these short comings. I’ve generally used it as a step in a data pipeline, where some intermittent state or aggregation where being stale/stable for a period of time is ok. Did this recently for a daily trends report on some news data - live querying the data is slow, but baking it off into a MV makes it much faster and keeps the query result from changing too rapidly to new data.