pg_ivm 1.13 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.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)

Browse pgsql-announce by date

  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