Re: When deleting the plpgsql function, release the CachedPlan of the function - Mailing list pgsql-hackers

From zengman
Subject Re: When deleting the plpgsql function, release the CachedPlan of the function
Date
Msg-id tencent_0BA97862026BC74E75238899@qq.com
Whole thread Raw
In response to When deleting the plpgsql function, release the CachedPlan of the function  ("zengman" <zengman@halodbtech.com>)
List pgsql-hackers
This patch only addresses the plan cache release for plpgsql (the procedural language) and does not cover SQL functions.
Since the src/backend/utils/cache/funccache.c file was introduced in PostgreSQL 18, I will first upgrade to version 18, 
then figure out how to extend the benefit to SQL functions. 
Additionally, I’m not entirely certain whether this patch’s modification is reasonable, or if it could lead to performance degradation. 
I might need everyone’s help to review it.




Attachment

pgsql-hackers by date:

Previous
From: John Naylor
Date:
Subject: Re: New commitfest app release on August 19th
Next
From: Hannu Krosing
Date:
Subject: Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible