Postgres Pro
Downloads
Home   >   mailing lists

pg_ivm 1.1 released - Mailing list pgsql-announce

From IVM Development Group via PostgreSQL Announce
Subject pg_ivm 1.1 released
Date
Msg-id 165600119161.879890.16218833840194450185@wrigleys.postgresql.org
Whole thread Raw
List pgsql-announce
Tree view
 

pg_ivm 1.1 released

IVM Development Group is pleased to announce the release of pg_ivm 1.1.

Changes since the v1.0 release include:

  • Adds support for PostgreSQL 13

  • Add support for aggregates

    In this release, built-in count, sum, and avg are supported.

  • Add support for TRUNCATE on base tables

  • Add refresh_immv() function

    This is a function to refresh IMMV like REFRESH MATERIALIZED VIEW command. It has a boolean parameter corresponding to the WITH [NO] DATA option. When this flag is set false, the IMMV gets unpopulated, and immediate maintenance on the IMMV is disabled.

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

This email was sent to you from IVM Development Group. It was delivered on their behalf by the PostgreSQL project. Any questions about the content of the message should be sent to IVM Development Group.

You were sent this email as a subscriber of the pgsql-announce mailinglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click the personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 

pgsql-announce by date:

Previous
From: Timescale via PostgreSQL Announce
Date:
Subject: Timescale's 2022 State of PostgreSQL Survey Is Now Open!
Next
From: Yandex via PostgreSQL Announce
Date:
Subject: Odyssey 1.3 released