Hacker News Reader

Comment by karmelapple | Hacker News Reader

I’d like to refresh a portion of a materialized view.

I have some big materialized views that take a long time to refresh concurrently, and I wish I could refresh a subset of the entire view’s data.

What do you mean by "refresh" here? Doesn't a materialized view get updated synchronously with updates to its constituent tables?

Nope, you must run

  REFRESH MATERIALIZED VIEW mymatview;

Which does a full view update.

I believe SQL Server does this, but Postgres does not.

If Postgres were ClickHouse, it would refresh materialized views synchronously on INSERT... but for Postgres it isn't.