pg_ivm: Recent Improvements and Future Directions in Incremental View Maintenance
October 20–23
Level: Intermediate
pg_ivm is an extension that enables Incremental View Maintenance (IVM) for PostgreSQL, updating materialized views by applying only incremental changes instead of rebuilding the entire view with REFRESH MATERIALIZED VIEW.
This talk briefly introduces the architecture and maintenance mechanism used by pg_ivm and reviews recent progress in the project, including recently added support for outer joins.
The talk also discusses ongoing work and future directions, including deferred maintenance approaches that could reduce update overhead while preserving the benefits of incremental view maintenance. Current limitations and remaining challenges will be examined, along with opportunities for future development.
