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

From Hou, Zhijie
Subject RE: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW
Date
Msg-id c1c4fd96d38a4c5b8b490d7b60f88c81@G08CNEXMBPEKD05.g08.fujitsu.local
Whole thread Raw
In response to Re: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
Responses Re: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW
List pgsql-hackers
> 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.

Best regards,
houzj



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [PATCH] LWLock self-deadlock detection
Next
From: Andres Freund
Date:
Subject: lwlock optimization opportunities