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-07-11 04:23:57
Message-ID: 20240711132357.fe3f78c184cfa99159208178@sranhm.sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 2 Jul 2024 17:03:11 +0900
Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp> wrote:

> On Sun, 31 Mar 2024 22:59:31 +0900
> Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp> wrote:
> > >
> > > 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.
>
> Attached is a rebased version, v33.

I updated the patch to bump up the version numbers in psql and pg_dump codes
from 17 to 18.

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
v34-0002-Add-relisivm-column-to-pg_class-system-catalog.patch text/x-diff 6.0 KB
v34-0001-Add-a-syntax-to-create-Incrementally-Maintainabl.patch text/x-diff 5.0 KB
v34-0011-Add-documentations-about-Incremental-View-Mainte.patch text/x-diff 24.7 KB
v34-0010-Add-regression-tests-for-Incremental-View-Mainte.patch text/x-diff 57.2 KB
v34-0009-Add-support-for-min-max-aggregates-for-IVM.patch text/x-diff 26.4 KB
v34-0008-Add-aggregates-support-in-IVM.patch text/x-diff 37.8 KB
v34-0007-Add-DISTINCT-support-for-IVM.patch text/x-diff 24.9 KB
v34-0006-Add-Incremental-View-Maintenance-support.patch text/x-diff 75.9 KB
v34-0005-Add-Incremental-View-Maintenance-support-to-psql.patch text/x-diff 4.7 KB
v34-0004-Add-Incremental-View-Maintenance-support-to-pg_d.patch text/x-diff 4.1 KB
v34-0003-Allow-to-prolong-life-span-of-transition-tables-.patch text/x-diff 6.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message vignesh C 2024-07-11 04:46:21 Re: Improving the latch handling between logical replication launcher and worker processes.
Previous Message Euler Taveira 2024-07-11 02:52:33 Re: improve performance of pg_dump with many sequences