Re: memory leak regression 9.1 versus 8.1 - Mailing list pgsql-hackers

From Joe Conway
Subject Re: memory leak regression 9.1 versus 8.1
Date
Msg-id 4FAB4E09.6080609@joeconway.com
Whole thread Raw
In response to Re: memory leak regression 9.1 versus 8.1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 05/09/2012 10:01 PM, Tom Lane wrote:
> Joe Conway <mail@joeconway.com> writes:
>> The attached one-liner seems to plug up the majority (although not quite
>> all) of the leakage.
> 
> Looks sane to me.  Are you planning to look for the remaining leakage?

Actually, now I'm not so sure there really are any other leaks. The last
test I ran, on 9.1 with the original data and plpgsql function, grew to:
 VIRT  RES  SHR 540m 327m 267m

but then stabilized there through the end of the query, which
successfully returned:
 count
----------28847766
(1 row)

This was with:

report_log=# show shared_buffers;shared_buffers
----------------256MB
(1 row)

report_log=# show work_mem;work_mem
----------16MB
(1 row)

So I think those memory usage numbers look reasonable.

The bug appears to go back through 8.4 -- kind of surprising no one has
complained before.

Joe


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


pgsql-hackers by date:

Previous
From: Josh Kupershmidt
Date:
Subject: psql: server version check for \dO
Next
From: "Erik Rijkers"
Date:
Subject: Re: Draft release notes complete