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-31 13:59:31
Message-ID: 20240331225931.712683cecb26862b73b2b822@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, 29 Mar 2024 23:47:00 +0900
Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp> wrote:

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

I found cfbot on FreeBSD still reported a failure due to
ENFORCE_REGRESSION_TEST_NAME_RESTRICTIONS because the regression test used
wrong role names. Attached is a fixed version, v32.

Regards,
Yugo Nagata

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

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

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Devrim Gündüz 2024-03-31 15:40:20 Re: Security lessons from liblzma
Previous Message walther 2024-03-31 13:34:23 Re: Building with musl in CI and the build farm