Re: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW - Mailing list pgsql-hackers

From Bharath Rupireddy
Subject Re: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW
Date
Msg-id CALj2ACV-Ru+DNDvxVLv9tZhPqxEema4YUGymXkDYS9UpS8Zm7g@mail.gmail.com
Whole thread Raw
In response to RE: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW  ("Hou, Zhijie" <houzj.fnst@cn.fujitsu.com>)
Responses Re: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW
Re: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW
List pgsql-hackers
On Wed, Dec 30, 2020 at 8:03 AM Hou, Zhijie <houzj.fnst@cn.fujitsu.com> wrote:
> > Yeah without explain analyze we can not show whether the parallelism is
> > picked in the test cases. What we could do is that we can add a plain RMV
> > test case in write_parallel.sql after CMV so that at least we can be ensured
> > that the parallelism will be picked because of the enforcement there. We
> > can always see the parallelism for the select part of explain analyze CMV
> > in write_parallel.sql and the same select query gets planned even in RMV
> > cases.
> >
> > IMO, the patch in this thread can go with test case addition to
> > write_parallel.sql. since it is very small.
> >
> > Thoughts?
>
> Yes, agreed.

Thanks. Added the test case. Attaching v2 patch. Please have a look.


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

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Cleanup some -I$(libpq_srcdir) in makefiles
Next
From: Bharath Rupireddy
Date:
Subject: Re: Parallel Inserts in CREATE TABLE AS