pg_materialized_views_refresh_topologically | Refresh PostgreSQL materialized views

pg_materialized_views_refresh_topologically is a Python library. pg_materialized_views_refresh_topologically has no bugs, it has no vulnerabilities, it has a Permissive License and it has low support. However pg_materialized_views_refresh_topologically build file is not available. You can download it from GitHub.

If your materialized views take a while to refresh, you'll probably want to refresh them regularly at a time when the database load is low, say every night at 3 a.m. Running a REFRESH on every materialized view every 24 hours works fine as long as all your materialized views obtain their data only from tables. Things become slightly more complicated once they obtain their data from other materialized views: Suppose materialized view B obtains its input from materialized view A, and you run a cron job every night at 3 a.m. which refreshes all materialized views in arbitrary order. If B is refreshed before A, the data in B will still be 24 hours old immediately after the cron job has finished. This python script solves this problem by representing the materialized views in a directed acyclic graph (DAG), where an incoming edge on B from A means that materialized view B receives input from materialized view A. This graph is then topologically sorted in order to execute all REFRESH MATERIALIZED VIEW statements in correct order.