IVM Development Group is pleased to announce the release of pg_ivm 1.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