| From: | Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | utility commands benefiting from parallel plan |
| Date: | 2017-02-24 06:13:01 |
| Message-ID: | CAJrrPGcY3SZa40vU+R8d8dunXp9JRcFyjmPn2RF9_4cxjHd7uA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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 | Content-Type | Size |
|---|---|---|
| utlity_write_with_query_parallel_1.patch | application/octet-stream | 10.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2017-02-24 06:15:09 | Re: Documentation improvements for partitioning |
| Previous Message | Dilip Kumar | 2017-02-24 06:00:40 | Re: Enabling parallelism for queries coming from SQL or other PL functions |