Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW

Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>

From: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>

To: PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2020-12-01T12:04:04Z

Lists: pgsql-hackers

Attachments

v1-0001-Allow-parallel-mode-in-REFRESH-MAT-VIEW-planning.patch (application/octet-stream) patch v1-0001

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

Commits

Enable parallelism in REFRESH MATERIALIZED VIEW.
- 9e7ccd9ef64d 14.0 landed
Allow DML commands that create tables to use parallel query.
- e9baa5e9fa14 11.0 cited