Re: Implementing Incremental View Maintenance

From: Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>
To: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
Cc: Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Takuma Hoshiai <hoshiai(at)sraoss(dot)co(dot)jp>, Michael Paquier <michael(at)paquier(dot)xyz>, Amit Langote <amitlangote09(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, kgrittn(at)gmail(dot)com
Subject: Re: Implementing Incremental View Maintenance
Date: 2020-07-09 12:20:41
Message-ID: CAKU4AWoqtKt4tA8aySSCY_eBxTk8NsJXrT5GqUrWX3htk-k_Bg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jul 7, 2020 at 3:26 PM Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp> wrote:

> >> Query checks for following restrictions are added:
> >
> >
> > Are all known supported cases listed below?
>
> They are "restrictions" and are not supported.
>

Yes, I missed the "not" word:(

>
> >> - inheritance parent table
> >> ...
> >> - targetlist containing IVM column
> >> - simple subquery is only supported
> >>
> >
> > How to understand 3 items above?
>
> The best way to understand them is looking into regression test.
>

Thanks for sharing, I will look into it.

--
Best Regards
Andy Fan

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2020-07-09 12:34:19 Re: replication_origin and replication_origin_lsn usage on subscriber
Previous Message Amit Kapila 2020-07-09 12:20:21 Re: Implement UNLOGGED clause for COPY FROM