4 ms·
> By default, materialized views in PostgreSQL are not automatically refreshed. If the underlying data changes, the materialized view remains stale until it's r
by MuffinFlavored 3y ago
> By default, materialized views in PostgreSQL are not automatically refreshed. If the underlying data changes, the materialized view remains stale until it's refreshed.
- joelhaasnoot 3y agoAnd only the owner can then refresh it - there are some annoying gotchas to them
- gigatexal 3y agoCan’t this be somewhat alleviated by running a job native on Postgres or some external one to refresh the views on a schedule? It’s not ideal or realtime but better than having it done as-hoc.
- jitl 3y agoRewriting a large view based on hundreds of gb of rows sounds like a recipe for a possible outage in an OLTP situation.
- tucnak 3y agohttps://docs.timescale.com/use-timescale/latest/continuous-aggregates/about-continuous-aggregates/ https://docs.timescale.com/use-timescale/latest/continuous-a...
- wayfinder 3y agoYeah but then it’s just lipstick on a pig. I can already create a regular table and update it myself. If my RBDMS adds materialized views, I want it to help me with it lol