Consider Parallel Append of partial paths for UNION [ALL].

Robert Haas <rhaas@postgresql.org>

Commit: 88ba0ae2aa4aaba8ea0d85c0ff81cc46912d9308
Author: Robert Haas <rhaas@postgresql.org>
Date: 2018-03-22T20:09:28Z
Releases: 11.0
Consider Parallel Append of partial paths for UNION [ALL].

Without this patch, we can implement a UNION or UNION ALL as an
Append where Gather appears beneath one or more of the Append
branches, but this lets us put the Gather node on top, with
a partial path for each relation underneath.

There is considerably more work that could be done to improve
planning in this area, but that will probably need to wait
for a future release.

Patch by me, reviewed and tested by Ashutosh Bapat and Rajkumar
Raghuwanshi.

Discussion: http://postgr.es/m/CA+TgmoaLRAOqHmMZx=ESM3VDEPceg+-XXZsRXQ8GtFJO_zbMSw@mail.gmail.com

Files

PathChange+/−
src/backend/optimizer/prep/prepunion.c modified +91 −2

Discussion