Hi,
I am asking the prev. question because there is no change in the query
plan (as far as I see) but the mem usage decreases from 258M to 16M.
Kaloyan Iliev
Tom Lane wrote:
>Kaloyan Iliev Iliev <news1(at)faith(dot)digsys(dot)bg> writes:
>
>
>>I have the following problem. A week ago we've migrated from PGv7.2.3 to
>>7.4.6. There were a lot of things in the apps to chenge but we made
>>them. But one query doesn't want to run. In the old PGv7.2.3 it passes
>>for 10 min. In the new one it gaves:
>>DBD::Pg::st execute failed: ERROR: out of memory
>>
>>
>
>Does setting enable_hashagg to OFF fix it?
>
> regards, tom lane
>
>
>
>