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.
