Horton

Initialize ExprStates once in run-time partition pruning

Alvaro Herrera <alvherre@alvh.no-ip.org>

View on postgr.es
Commit: 1957f8dabf8daa29c78d05f971dd665c9680a754
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2018-04-24T17:03:10Z
Releases: 11.0 
Initialize ExprStates once in run-time partition pruning

Instead of doing ExecInitExpr every time a Param needs to be evaluated
in run-time partition pruning, do it once during run-time pruning
set-up and cache the exprstate in PartitionPruneContext, saving a lot of
work.

Author: David Rowley
Reviewed-by: Amit Langote, Álvaro Herrera
Discussion: https://postgr.es/m/CAKJS1f8-x+q-90QAPDu_okhQBV4DPEtPz8CJ=m0940GyT4DA4w@mail.gmail.com

Files

PathChange+/−
src/backend/executor/execPartition.c modified +35 −0
src/backend/partitioning/partprune.c modified +17 −10
src/include/partitioning/partprune.h modified +9 −0

Discussion