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

karavelov@mail.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