On Thu, Jan 30, 2014 at 2:43 PM, Dattaram Porob <[email protected]> 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. -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
