]> granicus.if.org Git - postgresql/commit
Speed up array element assignment in plpgsql by caching type information.
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 26 Sep 2011 19:38:07 +0000 (15:38 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 26 Sep 2011 19:38:07 +0000 (15:38 -0400)
commit16762b519c9421ad5f1e373b1d89b0f2f6568769
tree8883fcc23b99be0f3cf47c8cf581c36d4844ac14
parent821fd903f9b7f5a8ca439b9b7cb6d2f54672582f
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
src/pl/plpgsql/src/gram.y
src/pl/plpgsql/src/pl_exec.c
src/pl/plpgsql/src/plpgsql.h
src/test/regress/expected/plpgsql.out
src/test/regress/sql/plpgsql.sql