pgsql: Save a few cycles in plpgsql simple-expression initialization. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Save a few cycles in plpgsql simple-expression initialization.
Date
Msg-id E1PBWI8-0008HF-Ez@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Save a few cycles in plpgsql simple-expression initialization.

Instead of using ExecPrepareExpr, call ExecInitExpr.  The net change here
is that we don't apply expression_planner() to the expression tree.  There
is no need to do so, because that tree is extracted from a fully planned
plancache entry, so all the needed work is already done.  This reduces
the setup costs by about a factor of 2 according to some simple tests.
Oversight noted while fooling around with the simple-expression code for
previous fix.

Branch
------
master

Details
-------
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=37e0a016547abb3526b685d7aacbd0a4d57f6937

Modified Files
--------------
src/pl/plpgsql/src/pl_exec.c |    5 +++--
1 files changed, 3 insertions(+), 2 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Fix plpgsql's handling of "simple" expression evaluation.
Next
From: Peter Eisentraut
Date:
Subject: pgsql: Make \? output of \dg and \du the same