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

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 (view raw or flat)
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

pgsql-bugs by date

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

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