pgsql: Avoid leaking memory while evaluating arguments for a table func
| От | Tom Lane |
|---|---|
| Тема | pgsql: Avoid leaking memory while evaluating arguments for a table func |
| Дата | |
| Msg-id | E1WxoLh-0002zm-JM@gemulon.postgresql.org обсуждение исходный текст |
| Список | pgsql-committers |
Avoid leaking memory while evaluating arguments for a table function. ExecMakeTableFunctionResult evaluated the arguments for a function-in-FROM in the query-lifespan memory context. This is insignificant in simple cases where the function relation is scanned only once; but if the function is in a sub-SELECT or is on the inside of a nested loop, any memory consumed during argument evaluation can add up quickly. (The potential for trouble here had been foreseen long ago, per existing comments; but we'd not previously seen a complaint from the field about it.) To fix, create an additional temporary context just for this purpose. Per an example from MauMau. Back-patch to all active branches. Branch ------ REL9_4_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/1044e79a0b7b21ddedd9e093394a34e8cc2d42bc Modified Files -------------- src/backend/executor/execQual.c | 15 +++++++++++---- src/backend/executor/nodeFunctionscan.c | 16 ++++++++++++++++ src/include/executor/executor.h | 1 + src/include/nodes/execnodes.h | 2 ++ 4 files changed, 30 insertions(+), 4 deletions(-)
В списке pgsql-committers по дате отправления: