Re: Incremental View Maintenance, take 2

From: Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp>
To: Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp>
Cc: Peter Smith <smithpb2250(at)gmail(dot)com>, jian he <jian(dot)universality(at)gmail(dot)com>, Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Incremental View Maintenance, take 2
Date: 2024-03-29 14:47:00
Message-ID: 20240329234700.73ff2e28c9248d29f8fa6a66@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, 4 Mar 2024 11:58:46 +0900
Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp> wrote:

> On Tue, 23 Jan 2024 16:23:27 +0900
> Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp> wrote:
>
> > On Mon, 22 Jan 2024 13:51:08 +1100
> > Peter Smith <smithpb2250(at)gmail(dot)com> wrote:
> >
> > > 2024-01 Commitfest.
> > >
> > > Hi, This patch has a CF status of "Needs Review" [1], but it seems
> > > like there was some CFbot test failure last time it was run [2].
> > > Please have a look and post an updated version if necessary.
>
> I attached a rebased patch-set, v30.

I attached a rebased patch-set, v31.

Also, I added a comment on RelationIsIVM() macro persuggestion from jian he.
In addition, I fixed a failure reported from cfbot on FreeBSD build caused by;

WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree

This warning was raised since I missed to modify outfuncs.c for a new field.

Regards,
Yugo Nagata

>
> Regards,
> Yugo Nagata
>
> --
> Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp>

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

Attachment Content-Type Size
v31-0001-Add-a-syntax-to-create-Incrementally-Maintainabl.patch text/x-diff 5.0 KB
v31-0002-Add-relisivm-column-to-pg_class-system-catalog.patch text/x-diff 6.0 KB
v31-0003-Allow-to-prolong-life-span-of-transition-tables-.patch text/x-diff 6.2 KB
v31-0004-Add-Incremental-View-Maintenance-support-to-pg_d.patch text/x-diff 4.1 KB
v31-0005-Add-Incremental-View-Maintenance-support-to-psql.patch text/x-diff 4.7 KB
v31-0006-Add-Incremental-View-Maintenance-support.patch text/x-diff 75.8 KB
v31-0007-Add-DISTINCT-support-for-IVM.patch text/x-diff 24.9 KB
v31-0008-Add-aggregates-support-in-IVM.patch text/x-diff 37.8 KB
v31-0009-Add-support-for-min-max-aggregates-for-IVM.patch text/x-diff 26.4 KB
v31-0010-Add-regression-tests-for-Incremental-View-Mainte.patch text/x-diff 56.9 KB
v31-0011-Add-documentations-about-Incremental-View-Mainte.patch text/x-diff 24.7 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2024-03-29 14:47:43 Re: Possibility to disable `ALTER SYSTEM`
Previous Message Alexander Pyhalov 2024-03-29 14:46:31 Re: Partial aggregates pushdown