pgsql: Fix interaction of parallel query with prepared statements. - Mailing list pgsql-committers

From Robert Haas
Subject pgsql: Fix interaction of parallel query with prepared statements.
Date
Msg-id E1cEItD-00084Q-PO@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix interaction of parallel query with prepared statements.

Previously, a prepared statement created via a Parse message could get
a parallel plan, but one created with a PREPARE statement could not.
This state of affairs was due to confusion on my (rhaas) part: I
erroneously believed that a CREATE TABLE .. AS EXECUTE statement could
only be performed with a prepared statement by PREPARE, but in fact
one created by a Prepare message works just as well.  Therefore, it
makes no sense to allow parallel query in one case but not the other.

To fix, allow parallel query with all prepared statements, but run
the parallel plan serially (i.e. without workers) in the case of
CREATE TABLE .. AS EXECUTE.  Also, document this.

Amit Kapila and Tobias Bussman, plus an extra sentence of
documentation by me.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/4212cb73262bbdd164727beffa4c4744b4ead92d

Modified Files
--------------
doc/src/sgml/parallel.sgml      | 9 +++++++++
src/backend/commands/prepare.c  | 2 +-
src/backend/executor/execMain.c | 7 ++++---
3 files changed, 14 insertions(+), 4 deletions(-)


pgsql-committers by date:

Previous
From: Robert Haas
Date:
Subject: pgsql: Fix interaction of parallel query with prepared statements.
Next
From: Andres Freund
Date:
Subject: Re: pgsql: Replace PostmasterRandom() with a stronger source, second attemp