pgsql: Speed up array element assignment in plpgsql by caching type inf - Mailing list pgsql-committers

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(-)