pgsql: Speed up array element assignment in plpgsql by caching type inf
Started by Tom Lanealmost 15 years ago1 messagescomitters
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(-)