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