On Thu, Dec 16, 2010 at 01:57, Anupama <anupama.mr@xxxxxxxxx> wrote: > Will the plan be freed when the db session / connection closes OR Yes. However results may vary with a connection pooler. FYI %_SHARED is global to session, not database global. (technically its global per perl interpreter, so plperl and plperlu have different %_SHARED). > Will it lead to any memory leaks ? Not unless you consider the act of storing something in %_SHARED a leak. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general