pgsql: Prevent leakage of cached plans and execution trees in plpgsql D
От | Tom Lane |
---|---|
Тема | pgsql: Prevent leakage of cached plans and execution trees in plpgsql D |
Дата | |
Msg-id | E1VhOV3-0001XT-VN@gemulon.postgresql.org обсуждение исходный текст |
Список | pgsql-committers |
Prevent leakage of cached plans and execution trees in plpgsql DO blocks. plpgsql likes to cache query plans and simple-expression execution state trees across calls. This is a considerable win for multiple executions of the same function. However, it's useless for DO blocks, since by definition those are executed only once and discarded. Nonetheless, we were allowing a DO block's expression execution trees to survive until end of transaction, resulting in a significant intra-transaction memory leak, as reported by Yeb Havinga. Worse, if the DO block exited with an error, the compiled form of the block's code was leaked till end of session --- along with subsidiary plancache entries. To fix, make DO blocks keep their expression execution trees in a private EState that's deleted at exit from the block, and add a PG_TRY block to plpgsql_inline_handler to make sure that memory cleanup happens even on error exits. Also add a regression test covering error handling in a DO block, because my first try at this broke that. (The test is not meant to prove that we don't leak memory anymore, though it could be used for that with a much larger loop count.) Ideally we'd back-patch this into all versions supporting DO blocks; but the patch needs to add a field to struct PLpgSQL_execstate, and that would break ABI compatibility for third-party plugins such as the plpgsql debugger. Given the small number of complaints so far, fixing this in HEAD only seems like an acceptable choice. Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/c7b849a89645212121da480091f87d11fac82495 Modified Files -------------- src/pl/plpgsql/src/pl_exec.c | 67 +++++++++++++++++++++++---------- src/pl/plpgsql/src/pl_handler.c | 49 +++++++++++++++++++++++- src/pl/plpgsql/src/plpgsql.h | 7 +++- src/test/regress/expected/plpgsql.out | 29 ++++++++++++++ src/test/regress/sql/plpgsql.sql | 20 ++++++++++ 5 files changed, 150 insertions(+), 22 deletions(-)
В списке pgsql-committers по дате отправления: