From: | Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Expand run-time partition pruning to work with MergeAppend |
Date: | 2018-07-19 10:50:04 |
Message-ID: | E1fg6VY-0004DW-Qw@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
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
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/5220bb7533f9891b1e071da6461d5c387e8f7b09
Modified Files
--------------
doc/src/sgml/perform.sgml | 12 +--
src/backend/executor/nodeAppend.c | 2 +-
src/backend/executor/nodeMergeAppend.c | 137 ++++++++++++++++++++++----
src/backend/nodes/copyfuncs.c | 1 +
src/backend/nodes/outfuncs.c | 2 +
src/backend/nodes/readfuncs.c | 1 +
src/backend/optimizer/plan/createplan.c | 46 +++++++--
src/include/nodes/execnodes.h | 9 ++
src/include/nodes/plannodes.h | 3 +
src/test/regress/expected/partition_prune.out | 137 ++++++++++++++++++++++++++
src/test/regress/sql/partition_prune.sql | 41 ++++++++
11 files changed, 356 insertions(+), 35 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2018-07-19 12:42:00 | pgsql: Fix comment. |
Previous Message | Michael Paquier | 2018-07-19 00:59:38 | Re: YA race condition in 001_stream_rep.pl (was Re: pgsql: Allow using the updated tuple while moving it to a different par) |