Re: Implementing Incremental View Maintenance

From: Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Cc: Greg Stark <stark(at)mit(dot)edu>, Zhihong Yu <zyu(at)yugabyte(dot)com>, Julien Rouhaud <rjuju123(at)gmail(dot)com>, "r(dot)takahashi_2(at)fujitsu(dot)com" <r(dot)takahashi_2(at)fujitsu(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>, Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
Subject: Re: Implementing Incremental View Maintenance
Date: 2022-04-22 02:29:39
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


On Fri, 1 Apr 2022 11:09:16 -0400
Greg Stark <stark(at)mit(dot)edu> wrote:

> This patch has bitrotted due to some other patch affecting trigger.c.
> Could you post a rebase?
> This is the last week of the CF before feature freeze so time is of the essence.

I attached a rebased patch-set.

Also, I made the folowing changes from the previous.

1. Fix to not use a new deptye

In the previous patch, we introduced a new deptye 'm' into pg_depend.
This deptype was used for looking for IVM triggers to be removed at
REFRESH WITH NO DATA. However, we decided to not use it for reducing
unnecessary change in the core code. Currently, the trigger name and
dependent objclass are used at that time instead of it.

As a result, the number of patches are reduced to nine from ten.

2. Bump the version numbers in psql and pg_dump

This feature's target is PG 16 now.

Yugo Nagata

Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp>

Attachment Content-Type Size
v27-0001-Add-a-syntax-to-create-Incrementally-Maintainabl.patch text/x-diff 6.7 KB
v27-0002-Add-relisivm-column-to-pg_class-system-catalog.patch text/x-diff 4.7 KB
v27-0003-Allow-to-prolong-life-span-of-transition-tables-.patch text/x-diff 6.2 KB
v27-0004-Add-Incremental-View-Maintenance-support-to-pg_d.patch text/x-diff 4.1 KB
v27-0005-Add-Incremental-View-Maintenance-support-to-psql.patch text/x-diff 4.8 KB
v27-0006-Add-Incremental-View-Maintenance-support.patch text/x-diff 91.9 KB
v27-0007-Add-aggregates-support-in-IVM.patch text/x-diff 55.7 KB
v27-0008-Add-regression-tests-for-Incremental-View-Mainte.patch text/x-diff 47.5 KB
v27-0009-Add-documentations-about-Incremental-View-Mainte.patch text/x-diff 25.2 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2022-04-22 03:21:43 Re: Replace open mode with PG_BINARY_R/W/A macros
Previous Message Japin Li 2022-04-22 01:51:03 Re: Replace open mode with PG_BINARY_R/W/A macros