Thanks,
It worked. I have read in the docs what this "enable_hashagg" do, but I couldn't understand it. What does it change?
From the Doc: ------- enable_hashagg (boolean)
Enables or disables the query planner's use of hashed aggregation
plan types. The default is on. This is used for debugging the query
planner.
--------
How it is used to debug the query planner? And why it lower the mem usage?
Thank you in advance.
Kaloyan Iliev
Tom Lane wrote:
Kaloyan Iliev Iliev <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
