pg_ivm v1.0 was officially released!
pg_ivm is an extension module that provides Incremental View Maintenance (IVM) feature, which is a way to make materialized views up-to-date in which only incremental changes are computed and applied on views rather than recomputing.
I have already explained pg_ivm in the previous post, but it was in alpha release stage at that time. The official v1.0 was released after a few bug fixes and code cleaning.
Also, RPM packages for pg_ivm are now available from PostgreSQL yum repository. So, you can also install pg_ivm for PostgreSQL 14 using yum or dnf intead of building from the source code, like:
$ sudo yum install pg_ivm_14
See the official instruction for details.
We would appreciate it if you could try pg_ivm v1.0 and give us any feedback!
Hi, Would it be possible for you to publish some benchmarks for the extension versus the mainline/branch one? and if possibly, also benchmark against readyset.io and polyscale.io just to see what performance looks like for e.g. Reads etc. versus above as well as PG15 beta etc.
ReplyDelete