Re: 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-03T12:42:56Z
Lists: pgsql-hackers
On Tue, Dec 1, 2020 at 5:34 PM Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com> wrote: > > 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? > Added this to commitfest, in case it is useful - https://commitfest.postgresql.org/31/2856/ 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