pgsql: Allow parallel workers to execute subplans.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Allow parallel workers to execute subplans.
Date: 2017-02-14 23:16:19
Message-ID: E1cdmKZ-0000Jd-Rv@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Allow parallel workers to execute subplans.

This doesn't do anything to make Param nodes anything other than
parallel-restricted, so this only helps with uncorrelated subplans,
and it's not necessarily very cheap because each worker will run the
subplan separately (just as a Hash Join will build a separate copy of
the hash table in each participating process), but it's a first step
toward supporting cases that are more likely to help in practice, and
is occasionally useful on its own.

Amit Kapila, reviewed and tested by Rafia Sabih, Dilip Kumar, and
me.

Discussion: http://postgr.es/m/CAA4eK1+e8Z45D2n+rnDMDYsVEb5iW7jqaCH_tvPMYau=1Rru9w@mail.gmail.com

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/5e6d8d2bbbcace304450b309e79366c0da4063e4

Modified Files
--------------
src/backend/executor/execParallel.c | 2 +-
src/backend/nodes/copyfuncs.c | 1 +
src/backend/nodes/equalfuncs.c | 1 +
src/backend/nodes/outfuncs.c | 1 +
src/backend/nodes/readfuncs.c | 1 +
src/backend/optimizer/plan/subselect.c | 17 +++++++++++++----
src/backend/optimizer/util/clauses.c | 16 +++++++---------
src/include/nodes/primnodes.h | 1 +
src/test/regress/expected/select_parallel.out | 26 ++++++++++++++++++++++++++
src/test/regress/sql/select_parallel.sql | 9 +++++++++
10 files changed, 61 insertions(+), 14 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2017-02-15 00:05:16 Re: Re: [COMMITTERS] pgsql: Remove all references to "xlog" from SQL-callable functions in p
Previous Message Robert Haas 2017-02-14 20:47:49 pgsql: Split index xlog headers from other private index headers.