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

From Robert Haas
Subject Re: [HACKERS] utility commands benefiting from parallel plan
Date
Msg-id CA+TgmobF9QnFU2cVUTCRu2FYWBb1ztgk36wY7ziWVXtnbdN7=w@mail.gmail.com
Whole thread Raw
In response to [HACKERS] utility commands benefiting from parallel plan  (Haribabu Kommi <kommi.haribabu@gmail.com>)
Responses Re: [HACKERS] utility commands benefiting from parallel plan
List pgsql-hackers
On Fri, Feb 24, 2017 at 11:43 AM, Haribabu Kommi
<kommi.haribabu@gmail.com> wrote:
> 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?

I think a lot more work than this will be needed.  See:

https://www.postgresql.org/message-id/CA+TgmoZC5ft_t9uQWSO5_1vU6H8oVyD=zyuLvRnJqTN==fvnhg@mail.gmail.com

...and the discussion which followed.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Make subquery alias optional in FROM clause
Next
From: Robert Haas
Date:
Subject: Re: ParallelFinish-hook of FDW/CSP (Re: [HACKERS] Steps inside ExecEndGather)