pgsql: Speed up array element assignment in plpgsql by caching type inf

Started by Tom Lanealmost 15 years ago1 messagescomitters
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us

Speed up array element assignment in plpgsql by caching type information.

Cache assorted data in the PLpgSQL_arrayelem struct to avoid repetitive
catalog lookups over multiple executions of the same statement.

Pavel Stehule

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/16762b519c9421ad5f1e373b1d89b0f2f6568769

Modified Files
--------------
src/pl/plpgsql/src/gram.y | 2 +
src/pl/plpgsql/src/pl_exec.c | 102 ++++++++++++++++++++------------
src/pl/plpgsql/src/plpgsql.h | 10 +++
src/test/regress/expected/plpgsql.out | 62 ++++++++++++++++++++
src/test/regress/sql/plpgsql.sql | 41 +++++++++++++
5 files changed, 179 insertions(+), 38 deletions(-)