Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vAkkZ-005fAX-Ui for pgsql-announce@arkaria.postgresql.org; Mon, 20 Oct 2025 07:56:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vAkkY-00Evj6-PV for pgsql-announce@arkaria.postgresql.org; Mon, 20 Oct 2025 07:56:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vAkkX-00Eviw-Vc for pgsql-announce@lists.postgresql.org; Mon, 20 Oct 2025 07:56:13 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vAkkR-003Bfl-1G for pgsql-announce@lists.postgresql.org; Mon, 20 Oct 2025 07:56:12 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:From:To:Subject: MIME-Version:Content-Type:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=LlYVVJLkCI7nfwHUV3bsDcRZH+NN8GDc4VAuEoNXN1g=; b=f31AIUPNWpT9IEGwf3GbqPcvgX T6olwFW5KtNLwuigFsJj7CA1ZUyJHstKFYOUzEQ25uHmYKTcQQfYbbJfzIU4BoyQkXElK0v9pmkkQ mjwk7nMF2/J/l3p0aFUewKs6tMpvv09aAzbcZm1tonFzOpxtmD6rt1dZpKXfFdXySzyWgXbvd71zO rNKBDrp3I3JzTbMAdUJRYQi7AuOZPC9KXnVnHBMi0lyqFvdIfjf9rhh7J+uE4qGIpHtk0FKr2Rkmt Civh4yQWYa5fr1L7nba8vRN1pITyOk3jnTKhDFozJNq1Zo0Lj5+VPs5yyLgJZ5vuM2PAmftgfx1ES HokDD3qg==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vAkkQ-002ja9-VE for pgsql-announce@lists.postgresql.org; Mon, 20 Oct 2025 07:56:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vAkkN-008hE2-1B for pgsql-announce@lists.postgresql.org; Mon, 20 Oct 2025 07:56:03 +0000 Content-Type: multipart/mixed; boundary="===============3288672067793904887==" MIME-Version: 1.0 Subject: pg_ivm 1.13 released To: PostgreSQL Announce From: IVM Development Group via PostgreSQL Announce Reply-To: nagata@sraoss.co.jp Date: Mon, 20 Oct 2025 07:55:08 +0000 Message-ID: <176094690838.765.12924701399520957637@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: 9d96d395f138ffcf1dca414c6a994da8f3f5823d18834f7a892912e71e3dabf5 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3288672067793904887== Content-Type: multipart/alternative; boundary="===============1149205288914628572==" MIME-Version: 1.0 --===============1149205288914628572== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable IVM Development Group is pleased to announce the release of [pg_ivm 1.13]( = https://github.com/sraoss/pg_ivm/releases/tag/v1.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 r= estrictions: - The target list of an outer join view must include all attributes use= d in join conditions. - The target list of an outer join view cannot contain non-strict funct= ions. - Only simple equijoins are supported. - The WHERE clause of an outer join view cannot contain non-null-reject= ing 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 (I= VM) feature. Incremental View Maintenance (IVM) is a way to make materialized views up-t= o-date in which only incremental changes are computed and applied on views rather tha= n recomputing.=20 pg_ivm provides a kind of immediate maintenance, in which materialized view= s are updated immediately after a base table is modified. =20 Source repository: [https://github.com/sraoss/pg_ivm](https://github.com/sr= aoss/pg_ivm) --===============1149205288914628572== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable pg_ivm 1.13 released
 

pg_ivm 1.13 released

IVM Development Group is pleased to announc= e 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 supp= orted, 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 equ= ijoins are supported.
    • The WHERE claus= e 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 w= as 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 tha= n recomputing.=20 pg_ivm provides a kind of immediate maintenance, in which materialized view= s are updated immediately after a base table is modified.

Source repository: h= ttps://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 shou= ld be sent to IVM Development Group.

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