September 26, 2024: PostgreSQL 17 Released!

pg_ivm 1.2 released

Posted on 2022-07-28 by IVM Development Group
Related Open Source

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

Changes since the v1.1 release include:

  • Add support for PostgreSQL 15 (Takuma Hoshiai, Yugo Nagata)

  • Add support for simple sub-queries in FROM clause (Takuma Hoshiai)

    Simple sub-queries that do not contain DISTINCT or an aggregate function can be used in FROM clause. Sub-queries in a target-list or WHERE clause (including EXISTS sub-queries) are not allowed.

  • Add support for built-in min and max aggregate functions (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