November 14, 2024: PostgreSQL 17.1, 16.5, 15.9, 14.14, 13.17, and 12.21 Released!

pg_ivm 1.6 released

Posted on 2023-09-04 by IVM Development Group
Related Open Source

IVM Development Group is pleased to announce the release of pg_ivm 1.6.

Changes since the v1.5.1 release include:

New feature

  • Add EXISTS clause support in IVM (Takuma Hoshiai)

    Correlated subqueries using EXISTS in WHERE clause are supported.

Bug fixes

  • Prohibit types without default btree opclass in the target list (Yugo Nagata)

Full Changelog:

https://github.com/sraoss/pg_ivm/compare/v1.5.1...v1.6

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