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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 05:27:17
Message-ID: 11834.1343280437@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

karavelov(at)mail(dot)bg writes:
> The query I have tried to use is:

> INSERT INTO preferences
> SELECT user_id,hstore(array_agg(name), array_agg(value))
> FROM old_prefs
> GROUP BY user_id;

> But the postgres backend consumed all the available memory (6G free + 4G
> swap) and finally was killed by the kernel.

Is there any reason to think this is an actual leak, and not just "you
were trying to compute an impractically large value"?

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Craig Ringer 2012-07-26 08:17:19 Re: BUG #6763: Severe memory leak with arrays and hstore
Previous Message karavelov 2012-07-26 01:32:12 BUG #6763: Severe memory leak with arrays and hstore