Skip site navigation (1) Skip section navigation (2)

Re: BUG #6763: Severe memory leak with arrays and hstore

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: karavelov(at)mail(dot)bg
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6763: Severe memory leak with arrays and hstore
Date: 2012-07-26 08:17:19
Message-ID: 5010FD0F.4020400@ringerc.id.au (view raw or flat)
Thread:
Lists: pgsql-bugs
On 07/26/2012 09:32 AM, karavelov(at)mail(dot)bg wrote:
> Finally I have managed to migrate it in batches of 100-200k user ids and
> disconnecting after each query in order to free the backend and leaked
> memory.
If you do it in batches, but you do NOT disconnect and reconnect, does 
the backend continue to grow?

What's the output of:

SELECT count(sub.user_id), to_char(AVG(sub.n_prefs), '99999.99') FROM (
SELECT user_id, count(name) AS n_prefs FROM old_prefs GROUP BY user_id) 
AS sub;

and

SELECT pg_size_pretty(pg_total_relation_size('old_prefs'));

?

--
Craig Ringer

In response to

Responses

pgsql-bugs by date

Next:From: Jez WainDate: 2012-07-26 09:13:03
Subject: Re: BUG #6758: ./configure script sets HAVE_WCSTOMBS_L 1
Previous:From: Tom LaneDate: 2012-07-26 05:27:17
Subject: Re: BUG #6763: Severe memory leak with arrays and hstore

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group