Postgres Pro
Downloads
Home   >   mailing lists

[HACKERS] utility commands benefiting from parallel plan - Mailing list pgsql-hackers

From Haribabu Kommi
Subject [HACKERS] utility commands benefiting from parallel plan
Date
Msg-id CAJrrPGcY3SZa40vU+R8d8dunXp9JRcFyjmPn2RF9_4cxjHd7uA@mail.gmail.com
Whole thread Raw
Responses Re: [HACKERS] utility commands benefiting from parallel plan  (Dilip Kumar <dilipbalaut@gmail.com>)
Re: [HACKERS] utility commands benefiting from parallel plan  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view
Hi Hackers,

Here I attached an implementation patch that allows
utility statements that have queries underneath such as
CREATE TABLE AS, CREATE MATERIALIZED VIEW
and REFRESH commands to benefit from parallel plan.

These write operations not performed concurrently by the
parallel workers, but the underlying query that is used by
these operations are eligible for parallel plans.

Currently the write operations are implemented for the
tuple dest types DestIntoRel and DestTransientRel.

Currently I am evaluating other write operations that can
benefit with parallelism without side effects in enabling them.

comments?

Regards,
Hari Babu
Fujitsu Australia
Attachment

pgsql-hackers by date:

Previous
From: Dilip Kumar
Date:
Subject: Re: [HACKERS] Enabling parallelism for queries coming from SQL orother PL functions
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] Documentation improvements for partitioning