Postgres Pro
Downloads
Home   >   mailing lists

[HACKERS] COPY (query) TO ... doesn't allow parallelism - Mailing list pgsql-hackers

From Andres Freund
Subject [HACKERS] COPY (query) TO ... doesn't allow parallelism
Date
Msg-id 20170531231958.ihanapplorptykzm@alap3.anarazel.de
Whole thread Raw
Responses Re: [HACKERS] COPY (query) TO ... doesn't allow parallelism  (Dilip Kumar <dilipbalaut@gmail.com>)
Re: [HACKERS] COPY (query) TO ... doesn't allow parallelism  (Amit Kapila <amit.kapila16@gmail.com>)
Re: [HACKERS] COPY (query) TO ... doesn't allow parallelism  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
Hi,

At the moment $subject doesn't allow parallelism, because copy.c's
pg_plan_query() invocation doesn't set the CURSOR_OPT_PARALLEL_OK
flag.

To me that appears to be an oversight rather than intentional.  A
somewhat annoying one at that, because it's not uncommong to use COPY to
execute reports to a CSV file and such.

Robert, am I missing a complication?

I personally think we should fix this in 9.6 and 10, but I've to admit
I'm not entirely impartial, because Citus hit this...

Greetings,

Andres Freund

pgsql-hackers by date:

Previous
From: Mark Dilger
Date:
Subject: Re: [HACKERS] pg_class.relpartbound definition overly brittle
Next
From: Stephen Frost
Date:
Subject: Re: [JDBC] [HACKERS] Channel binding support for SCRAM-SHA-256