Re: BUG #12183: Memory leak in long running sessions

Valentine Gogichashvili <valgog(at)gmail(dot)com> wrote:

> Can we collect some more information that would give more hints
> on what is going on there?

As Tom already said, a reproducible test case (i.e., a script which
a developer can run starting from an empty database) which
demonstrates the problem would be ideal. If you can't produce
that, install smem (if it's not already installed) and run this at
intervals (beginning, middle, and end would probably suffice):

smem -trs uss

The other thing that would give valuable information would be to
set overcommit_memory to 2 and overcommit_ratio to something like
80. If there is a memory leak in PostgreSQL, it will probably dump
a memory map when an allocation attempt fails. It would also be
great if you could enable core dumps for postgres and get a
backtrace from the point of failure in this configuration.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company