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.3 released |
Date: | 2022-10-03 07:51:47 |
Message-ID: | 166478350706.662.7765803307590489068@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.3]( https://github.com/sraoss/pg_ivm/releases/tag/v1.3 ).
Changes since the v1.2 release include:
### New feature
* Add get_immv_def function (Takuma Hoshiai)
This function reconstructs the underlying SELECT command for an IMMV.
### Bug fixes
* Fix a maintenance failure of MIN/MAX aggregate views whose columns had alias names (Yugo Nagata)
Views that have a min/max aggregate with an alias name (e.g. `min(j) as min_j`) were not correctly handled and an error could be raised when a tuple was deleted from a base table.
* Fix possible incorrect maintenance due to XID wraparound or using sub-transactions (Yugo Nagata)
* Fix a bug that any table cannot be dropped by non-superuser (Yugo Nagata)
### 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 | PL/Haskell via PostgreSQL Announce | 2022-10-05 01:20:53 | PL/Haskell v1.0 Released |
Previous Message | MigOps via PostgreSQL Announce | 2022-10-02 16:50:19 | pg_dbms_job v1.5.0 released |