Re: utility commands benefiting from parallel plan

Haribabu Kommi <kommi.haribabu@gmail.com>

From: Haribabu Kommi <kommi.haribabu@gmail.com>

To: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>

Date: 2017-09-01T07:01:03Z

Lists: pgsql-hackers

Attachments

0001-Make-parallel-eligible-for-utility-commands-undernea_V3.patch (application/octet-stream) patch 0001

Hi All,

Attached a rebased patch that supports parallelism for the queries
that are underneath of some utility commands such as CREATE TABLE AS
and CREATE MATERIALIZED VIEW.

Note: This patch doesn't make the utility statement (insert operation)
to run in parallel. It only allows the select query to be parallel if the
query
is eligible for parallel.

Regards,
Hari Babu
Fujitsu Australia

Commits

Allow DML commands that create tables to use parallel query.
- e9baa5e9fa14 11.0 landed