Re: Plperl caching prepared queries and cleanup - Mailing list pgsql-general

From Alex Hunsaker
Subject Re: Plperl caching prepared queries and cleanup
Date
Msg-id AANLkTikwS1PeRFOSDv9BSvW4c4t0vP+6Bg6ULKm7JNJD@mail.gmail.com
Whole thread Raw
In response to Plperl caching prepared queries and cleanup  (Anupama <anupama.mr@gmail.com>)
List pgsql-general
On Thu, Dec 16, 2010 at 01:57, Anupama <anupama.mr@gmail.com> 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.

pgsql-general by date:

Previous
From: Bryan Montgomery
Date:
Subject: Re: Searching array fields - or should I redesign?
Next
From: Vincent Veyron
Date:
Subject: Re: Searching array fields - or should I redesign?