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