Re: EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW

From: Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>
To: Japin Li <japinli(at)hotmail(dot)com>
Cc: Zhihong Yu <zyu(at)yugabyte(dot)com>, David Steele <david(at)pgmasters(dot)net>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW
Date: 2021-03-15 03:32:02
Message-ID: CALj2ACV5qXtiiWP4Dk+f0fxe-6cE4-YMmivdViXM5Y9Nsj1YdQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Mar 13, 2021 at 7:00 AM Japin Li <japinli(at)hotmail(dot)com> wrote:
>
> On Mon, 08 Mar 2021 at 12:28, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> wrote:
> > On Sun, Mar 7, 2021 at 10:13 PM Zhihong Yu <zyu(at)yugabyte(dot)com> wrote:
> >> Hi,
> >>
> >> + * EXPLAIN ANALYZE CREATE TABLE AS or REFRESH MATERIALIZED VIEW
> >> + * WITH NO DATA is weird.
> >>
> >> Maybe it is clearer to spell out WITH NO DATA for both statements, instead of sharing it.
> >
> > Done that way.
> >
> >> - if (!stmt->skipData)
> >> + if (!stmt->skipData && !explainInfo)
> >> ...
> >> + else if (explainInfo)
> >>
> >> It would be cleaner to put the 'if (explainInfo)' as the first check. That way, the check for skipData can be simplified.
> >
> > Changed.
> >
> > Thanks for review comments. Attaching v7 patch set with changes only
> > in 0002 patch. Please have a look.
> >
>
> The v7 patch looks good to me, and there is no other advice, so I change
> the status to "Ready for Committer".

Thanks for the review.

With Regards,
Bharath Rupireddy.
EnterpriseDB: http://www.enterprisedb.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Julien Rouhaud 2021-03-15 03:33:20 Re: REINDEX backend filtering
Previous Message Bharath Rupireddy 2021-03-15 03:27:57 Re: A new function to wait for the backend exit after termination