From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | "Hackers (PostgreSQL)" <pgsql-hackers(at)postgresql(dot)org> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: memory leak regression 9.1 versus 8.1 |
Date: | 2012-05-10 00:06:30 |
Message-ID: | 4FAB0686.2040908@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
Attachment | Content-Type | Size |
---|---|---|
9.1-memory-leak-regression.sql | text/x-sql | 1.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2012-05-10 01:03:53 | Re: synchronous_commit and remote_write |
Previous Message | Josh Berkus | 2012-05-10 00:02:57 | Re: synchronous_commit and remote_write |