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)
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 |