pg_ivm 1.11 (2025-05-26)
pg_ivm is an extension module for PostgreSQL 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.
What's Changed
Bug Fixes
Fix maintenance failure with columns whose names include capital letter by @yugo-n in #135
This bug was introduced in the previous release (v1.10). When a table has a column with a capital letter in its name, incremental view maintenance failed because the column name was parsed as lowercase.
Fix build failures on Windows environments by @yuta-masano in #139
Previously, the lack of PGDLLEXPORT on some functions declarations caused linkage when building with MSVC.
Fix potential segmentation fault in create_immv by @yugo-n in #141
A code issue caused a segmentation fault when building with MSVC, although the problem was not observed on Linux.
Source Code Improvements
Documentation
- Add an example of on renaming IMMV to README @qmitchell-aa in #123
- Fix typo in README by @ivan in #134
New Contributors
- @kyungmax made their first contribution in #129
- @ivan made their first contribution in #134
- @yuta-masano made their first contribution in #139
- @qmitchell-aa made their first contribution in #123
Full Changelog: v1.10...v1.11
The IVM Development Group has announced a new release of pg_ivm, which is an extension module designed for PostgreSQL that provides the Incremental View Maintenance (IVM) feature. Any modifications to a base table promptly update the materialized views. The most recent update addresses issues concerning maintenance failures associated with capitalized column names, build failures in Windows environments, and possible segmentation faults in create_immv. Enhancements consist of the inclusion of meson.build, the correction of typographical errors, and the addition of documentation examples.
