pg_ivm 1.2 (2022-7-25)

• 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)

pg_ivm 1.1 (2022-6-23)

• Adds support for PostgreSQL 13 (Tatsuo Ishii)

• Add support for aggregates (Yugo Nagata)

  In this release, built-in count, sum, and avg are supported.

• Add support for TRUNCATE on base tables (Yugo Nagata)

• Add refresh_immv() function (Takuma Hoshiai, Yugo Nagata)

  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.

• Fix error codes for invalid input to create_immv() (Yugo Nagata)

pg_ivm 1.0 (2022-4-28)

This is the first release of pg_ivm extension module.

pg_ivm provides Incremnetal View Maintenance (IVM) feature for PostgreSQL.

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.

Compatible with PostgreSQL 14
Supporting Selection-Projection-Join, and DISTINCT

pg_ivm 1.0 alpha (2022-3-31)

This is the alpha release of pg_ivm extension module.

pg_ivm provides Incremnetal View Maintenance (IVM) feature for PostgreSQL.

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.

• Compatible with PostgreSQL 14
• Supporting Selection-Projection-Join, and DISTINCT