Re: Implementing Incremental View Maintenance

From: Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp>
To: Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, 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 05:58:01
Message-ID: 20220422145801.2a1ded1096bbe5cec983cfdc@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, 22 Apr 2022 11:29:39 +0900
Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp> wrote:

> Hi,
>
> 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.

Sorry, I revert this change. It was too early to bump up the
version number.

--
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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2022-04-22 07:37:30 Re: wrong fds used for refilenodes after pg_upgrade relfilenode changes Reply-To:
Previous Message Thomas Munro 2022-04-22 05:10:49 Re: A qsort template