Re: When deleting the plpgsql function, release the CachedPlan of the function

Поиск
Список
Период
Сортировка
От Matthias van de Meent
Тема Re: When deleting the plpgsql function, release the CachedPlan of the function
Дата
Msg-id CAEze2WgOLDRZr5Bu45iZCmdRPuC0TwFz5+yJRuD6zkz_ak8mRg@mail.gmail.com
обсуждение исходный текст
Ответ на When deleting the plpgsql function, release the CachedPlan of the function  ("zengman" <zengman@halodbtech.com>)
Ответы Re: When deleting the plpgsql function, release the CachedPlan of the function
Список pgsql-hackers
On Mon, 18 Aug 2025 at 08:51, zengman <zengman@halodbtech.com> wrote:
>
> Hi, hackers
>
> I have observed an issue where the CachedPlan corresponding to a function/procedure is not released when we execute
the"DROP FUNCTION\PROCEDURE" command. A patch to resolve this problem is attached.
 

I'm trying to figure out how this patch is supposed to handle
concurrent sessions dropping a procedure that has cached plans. AFAIK,
we don't execute RemoveFunctionById in other sessions, so this would
still leave the plan caches active for other backends, right?

Kind regards,

Matthias van de Meent
Databricks



В списке pgsql-hackers по дате отправления: