samol
Reputation: 20590
Postgres: How to auto refresh materialized views per interval
Is it possible to automatically refresh a materialized view every 15 minutes or does it have to happen in the client code?
Upvotes: 0
Views: 619
Answers (1)
Cody Caughlan
Reputation: 32748
It will have to be done in an external process. As of Postgres 9.3 doesn't offer a way to have the system refresh materialized views itself on a scheduled basis.
Upvotes: 1
Related Questions
- Postgres Materialized View Auto Refresh
- How to monitor refreshing of materialized views in PostgreSQL?
- How to refresh a materialized view incrementally in PostgreSQL i.e. only for the data that is new or has changed?
- Trigger function to refresh Postgres materialized view and capture refresh end time?
- Refresh a materialized view automatically using a rule or notify
- refresh materialized view periodically postgres
- How to refresh a materialized view as soon as the day gets over in postgres
- pgsql Materialized view refresh
- PostgreSQL 10: is there a scheduler function that can auto refresh a materialized view per interval of time?
- Automatically refreshing Materialized view at Irregular time intervals