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.13 released |
Date: | 2025-10-20 07:55:08 |
Message-ID: | 176094690838.765.12924701399520957637@wrigleys.postgresql.org |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce |
IVM Development Group is pleased to announce the release of [pg_ivm 1.13]( https://github.com/sraoss/pg_ivm/releases/tag/v1.13 ).
Changes since the v1.12 release include:
### New feature
* Add support for outer joins (Yugo Nagata)
Views that include outer joins are now supported, under the following restrictions:
- The target list of an outer join view must include all attributes used in join conditions.
- The target list of an outer join view cannot contain non-strict functions.
- Only simple equijoins are supported.
- The WHERE clause of an outer join view cannot contain non-null-rejecting predicates.
- Aggregates are not supported in outer join views.
- Subqueries are not supported in outer join views.
#### Acknowledgements
The development of the outer join support was sponsored by Mediapart.
### 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 | HexaCluster via PostgreSQL Announce | 2025-10-20 07:56:45 | credcheck v4.1 has been released |
Previous Message | PostgreSQL Contributors Team via PostgreSQL Announce | 2025-10-17 09:55:50 | New PostgreSQL Contributors 2025 |