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-02 08:03:11
Message-ID: 20240702170311.1ddb417759a48ff12c555b92@sranhm.sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Regards,
Yugo Nagata

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

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Langote 2024-07-02 08:03:48 Re: pgsql: Add more SQL/JSON constructor functions
Previous Message Dean Rasheed 2024-07-02 07:57:40 Re: gamma() and lgamma() functions