pg_ivm 1.5 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.5 released
Date: 2023-01-31 19:48:55
Message-ID: 167519453577.640483.6607709124630395626@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.5]( https://github.com/sraoss/pg_ivm/releases/tag/v1.5 ).

Changes since the v1.4 release include:

### New feature

* Add CTE support (Yugo Nagata)

Simple CTEs (WITH queries) which do not contain aggregates or DISTINCT are supported similarly to simple sub-queries.

### Bug fixes

* Fix automatic index creation on views containing a subquery (Yugo Nagata)

Previously, a unique index could not be created properly when an IMMV containing a subquery was created even if all primary key attributes appeared in the target list.

* Fix to allow generate_series in FROM clause (Yugo Nagata)

Using generate_series caused an error due to an ambiguous reference at the maintenance time because this function is used internally.

* Prohibit to create IMMVs using subqueries in a function argument or in an expression (Yugo Nagata)

For example, views like

- `SELECT ... FROM func(..., (SELECT ... FROM ...), ..) ...;`
- `SELECT expr(SELECT ... FROM ...) FROM ...;`

cannot be maintained correctly, so they are prohibited.

**Full Changelog**: https://github.com/sraoss/pg_ivm/compare/1.4...v1.5

### 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 PostgreSQL User Group Germany via PostgreSQL Announce 2023-02-01 16:52:27 PostgreSQL Conference Germany 2023
Previous Message pgDay Paris via PostgreSQL Announce 2023-01-31 19:47:34 Subject: pgDay Paris 2023 — Schedule Published