WORLDTECH NEWS Global technology intelligence.Contact
← Back to WORLDTECH

pg_ivm 1.16 released

Organized office desk with a laptop, calculator, and tablet ready for business tasks.
Illustrative photo.Photo by Towfiqu barbhuiya on Pexels

What happened

IVM Development Group is pleased to announce the release of pg_ivm 1.16 . Prevent spurious transaction failures during incremental maintenance (Dzmitry Levankou) During incremental maintenance, locks are acquired on the materialized view to prevent anomalies caused by concurrent maintenance.

Fix OID handling when OID exceeds INT_MAX (Artur Aleksander Kanošin) View maintenance failed when the global OID counter exceeds INT_MAX. Previously, due to the timing of lock release during commit, a transaction could fail unnecessarily with a lock error even though no concurrent incremental maintenance was actually in progress.

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.

Sources & evidence