Re: Plperl caching prepared queries and cleanup

From: Alex Hunsaker <badalex(at)gmail(dot)com>
To: Anupama <anupama(dot)mr(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Plperl caching prepared queries and cleanup
Date: 2010-12-16 23:16:41
Message-ID: AANLkTikwS1PeRFOSDv9BSvW4c4t0vP+6Bg6ULKm7JNJD@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Dec 16, 2010 at 01:57, Anupama <anupama(dot)mr(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vincent Veyron 2010-12-16 23:52:42 Re: Searching array fields - or should I redesign?
Previous Message Bryan Montgomery 2010-12-16 20:18:20 Re: Searching array fields - or should I redesign?