pgsql: Fix up parallel-safety marking for appendrels. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Fix up parallel-safety marking for appendrels.
Date
Msg-id E1bJpOQ-00077w-Ge@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix up parallel-safety marking for appendrels.

The previous coding assumed that the value derived by
set_rel_consider_parallel() for an appendrel parent would be accurate for
all the appendrel's children; but this is not so, for example because one
child might scan a temp table.  Instead, apply set_rel_consider_parallel()
to each child rel as well as the parent, and then take the AND of the
results as controlling parallel safety for the appendrel as a whole.

(We might someday be able to deal more intelligently than this with cases
in which some of the childrels are parallel-safe and others not, but that's
for later.)

Robert Haas and Tom Lane

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/4ea9948e58a57316330acb1701f979bc1e872f50

Modified Files
--------------
src/backend/optimizer/path/allpaths.c | 73 ++++++++++++++++++++++++++++-------
1 file changed, 58 insertions(+), 15 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Allow treating TABLESAMPLE scans as parallel-safe.
Next
From: Tom Lane
Date:
Subject: pgsql: Allow RTE_SUBQUERY rels to be considered parallel-safe.