Hi, I think we can pass CURSOR_OPT_PARALLEL_OK to pg_plan_query() for refresh mat view so that parallelism can be considered for the SELECT part of the previously created mat view. The refresh mat view queries can be faster in cases where SELECT is parallelized.
Attaching a small patch. Thoughts? With Regards, Bharath Rupireddy. EnterpriseDB: http://www.enterprisedb.com
v1-0001-Allow-parallel-mode-in-REFRESH-MAT-VIEW-planning.patch
Description: Binary data