Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_ivm 1.9 released

pg_ivm 1.9 released

From
IVM Development Group via PostgreSQL Announce
Date:
 

pg_ivm 1.9 released

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

This email was sent to you from IVM Development Group. It was delivered on their behalf by the PostgreSQL project. Any questions about the content of the message should be sent to IVM Development Group.

You were sent this email as a subscriber of the pgsql-announce mailinglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click the personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.