public inbox for [email protected]
help / color / mirror / Atom feedFrom: IVM Development Group via PostgreSQL Announce <[email protected]>
To: PostgreSQL Announce <[email protected]>
Subject: pg_ivm 1.9 released
Date: Wed, 31 Jul 2024 13:58:36 +0000
Message-ID: <[email protected]> (raw)
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)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: pg_ivm 1.9 released
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox