Horton

Expand run-time partition pruning to work with MergeAppend

Heikki Linnakangas <heikki.linnakangas@iki.fi>

View on postgr.es
Commit: 5220bb7533f9891b1e071da6461d5c387e8f7b09
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
Date: 2018-07-19T10:49:43Z
Releases: 12.0 
Expand run-time partition pruning to work with MergeAppend

This expands the support for the run-time partition pruning which was added
for Append in 499be013de to also allow unneeded subnodes of a MergeAppend
to be removed.

Author: David Rowley
Discussion: https://www.postgresql.org/message-id/CAKJS1f_F_V8D7Wu-HVdnH7zCUxhoGK8XhLLtd%3DCu85qDZzXrgg%40mail.gmail.com

Files

PathChange+/−
doc/src/sgml/perform.sgml modified +6 −6
src/backend/executor/nodeAppend.c modified +1 −1
src/backend/executor/nodeMergeAppend.c modified +116 −21
src/backend/nodes/copyfuncs.c modified +1 −0
src/backend/nodes/outfuncs.c modified +2 −0
src/backend/nodes/readfuncs.c modified +1 −0
src/backend/optimizer/plan/createplan.c modified +39 −7
src/include/nodes/execnodes.h modified +9 −0
src/include/nodes/plannodes.h modified +3 −0
src/test/regress/expected/partition_prune.out modified +137 −0
src/test/regress/sql/partition_prune.sql modified +41 −0

Documentation touched

Discussion