Re: memory leak regression 9.1 versus 8.1

On 05/09/2012 03:36 PM, Joe Conway wrote:
> Good call -- of course that just means my contrived example fails to
> duplicate the real issue :-(
> In the real example, even with work_mem = 1 MB I see the same behavior
> on 9.1.

OK, new script. This more faithfully represents the real life scenario,
and reproduces the issue on HEAD with out-of-the-box config settings,
versus 8.1 which completes the query having never exceeded a very modest
memory usage:

---------------
On pg 8.1 with out of the box config:
VIRT  RES  SHR
199m  11m 3032
---------------
On pg head with out of the box config:
VIRT  RES  SHR
1671m 1.5g  16m
---------------

I have not tried your ulimit suggestion yet but will do that next.

Joe

-- 
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support