Postgres Pro
Downloads
Home   >   mailing lists

Re: Re: Increased memory utilization by pgsql backend after upgrade from 9.1.3 to 9.2.6 - Mailing list pgsql-performance

From Claudio Freire
Subject Re: Re: Increased memory utilization by pgsql backend after upgrade from 9.1.3 to 9.2.6
Date
Msg-id CAGTBQpacfi+LYBFTZdn9bE0pWBoTTpAt9yV4j2vqm+U2dx4zfg@mail.gmail.com
Whole thread Raw
In response to Re: Increased memory utilization by pgsql backend after upgrade from 9.1.3 to 9.2.6  (Dattaram Porob <dattaram.porob@gmail.com>)
List pgsql-performance
Tree view 
On Thu, Jan 30, 2014 at 2:43 PM, Dattaram Porob
<dattaram.porob@gmail.com> wrote:
>
> Looks like this memory is being used to cache the query plan. Any ideas, why
> it is occupying such a huge heap in 9.2.6 as compared to 9.1.3 ? I know that
> the same SQL function occupies around 25MB heap in 9.1.3.
>
> Any thoughts/comments?

I believe (not sure) that you can release that memory by issuing a
DISCARD ALL when returning a connection to the pool.

pgsql-performance by date:

Previous
From: "Pweaver (Paul Weaver)"
Date:
Subject: Postgres Query Plan Live Lock
Next
From: Peter Geoghegan
Date:
Subject: Re: Postgres Query Plan Live Lock