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.