Speed up array element assignment in plpgsql by caching type information.
Tom 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
Files
| Path | Change | +/− |
|---|---|---|
| src/pl/plpgsql/src/gram.y | modified | +2 −0 |
| src/pl/plpgsql/src/pl_exec.c | modified | +64 −38 |
| src/pl/plpgsql/src/plpgsql.h | modified | +10 −0 |
| src/test/regress/expected/plpgsql.out | modified | +62 −0 |
| src/test/regress/sql/plpgsql.sql | modified | +41 −0 |