| 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.1 released |
| Date: | 2022-06-23 16:19:51 |
| Message-ID: | 165600119161.879890.16218833840194450185@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.1]( https://github.com/sraoss/pg_ivm/releases/tag/v1.1 ).
Changes since the v1.0 release include:
* Adds support for PostgreSQL 13
* Add support for aggregates
In this release, built-in count, sum, and avg are supported.
* Add support for TRUNCATE on base tables
* Add refresh_immv() function
This is a function to refresh IMMV like REFRESH MATERIALIZED VIEW command. It has a boolean parameter corresponding to the WITH [NO] DATA option. When this flag is set false, the IMMV gets unpopulated, and immediate maintenance on the IMMV is disabled.
### 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 | Yandex via PostgreSQL Announce | 2022-06-27 23:45:59 | Odyssey 1.3 released |
| Previous Message | Timescale via PostgreSQL Announce | 2022-06-23 16:17:25 | Timescale's 2022 State of PostgreSQL Survey Is Now Open! |