pgsql: Initialize ExprStates once in run-time partition pruning

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Initialize ExprStates once in run-time partition pruning
Date: 2018-04-24 17:04:06
Message-ID: E1fB1MM-00013w-Mg@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2018-04-25 02:04:29 pgsql: Update ExecInitPartitionInfo comment
Previous Message David Rowley 2018-04-24 01:53:32 Re: pgsql: Remove useless default clause in switch