pgsql: Initialize ExprStates once in run-time partition pruning - Mailing list pgsql-committers

From Alvaro Herrera
Subject pgsql: Initialize ExprStates once in run-time partition pruning
Date
Msg-id E1fB1MM-00013w-Mg@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/1957f8dabf8daa29c78d05f971dd665c9680a754

Modified Files
--------------
src/backend/executor/execPartition.c | 35 +++++++++++++++++++++++++++++++++++
src/backend/partitioning/partprune.c | 27 +++++++++++++++++----------
src/include/partitioning/partprune.h |  9 +++++++++
3 files changed, 61 insertions(+), 10 deletions(-)


pgsql-committers by date:

Previous
From: David Rowley
Date:
Subject: Re: pgsql: Remove useless default clause in switch
Next
From: Alvaro Herrera
Date:
Subject: pgsql: Update ExecInitPartitionInfo comment