2 ms·
What do you mean by "refresh" here? Doesn't a materialized view get updated synchronously with updates to its constituent tables?
by dboreham 4y ago
What do you mean by "refresh" here? Doesn't a materialized view get updated synchronously with updates to its constituent tables?
- samanator 4y agoNope, you must run REFRESH MATERIALIZED VIEW mymatview; Which does a full view update. See https://www.postgresql.org/docs/current/rules-materializedviews.html https://www.postgresql.org/docs/current/rules-materializedvi...
- Merad 4y agoI believe SQL Server does this, but Postgres does not.
- zX41ZdbW 4y agoIf Postgres were ClickHouse, it would refresh materialized views synchronously on INSERT... but for Postgres it isn't.