IVM Development Group is pleased to announce the release of pg_ivm 1.9.

Changes since the v1.8 release include:

Bug fixes

• Add support for PostgreSQL 17 (Yugo Nagata, Takuma Hoshiai, reshke)

  This contains the following changes:

• Change functions to use a safe search_path during maintenance operations when used with PostgreSQL 17

  This prevents maintenance operations (automatic maintenance of IMMVs and refresh_immv) from performing unsafe access. Functions used by IMMVs that need to reference non-default schemas must specify a search path during function creation.

• refresh_immv can be executed by users with the MAINTAIN privilege when used with PostgreSQL 17

About pg_ivm

pg_ivm is an extension module that provides Incremental View Maintenance (IVM) feature.

Incremental View Maintenance (IVM) is a way to make materialized views up-to-date in which only incremental changes are computed and applied on views rather than recomputing. pg_ivm provides a kind of immediate maintenance, in which materialized views are updated immediately after a base table is modified.

Source repository: https://github.com/sraoss/pg_ivm