pg_ivm 1.9 released

From: IVM Development Group via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org>
Subject: pg_ivm 1.9 released
Date: 2024-07-31 13:58:36
Message-ID: 172243431643.915373.3788895852709899170@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce

IVM Development Group is pleased to announce the release of [pg_ivm 1.9]( https://github.com/sraoss/pg_ivm/releases/tag/v1.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](https://github.com/sraoss/pg_ivm)

Browse pgsql-announce by date

  From Date Subject
Next Message United States PostgreSQL Association via PostgreSQL Announce 2024-07-31 14:26:56 PGConf NYC 2024 Schedule Announced!
Previous Message pgAdmin Development Team via PostgreSQL Announce 2024-07-29 17:15:43 pgAdmin 4 v8.10 Released