Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance problem from migrating between versions! - Mailing list pgsql-performance

From Tom Lane
Subject Re: Performance problem from migrating between versions!
Date
Msg-id 2253.1105978380@sss.pgh.pa.us
Whole thread Raw
In response to Performance problem from migrating between versions!  (Kaloyan Iliev Iliev <news1@faith.digsys.bg>)
Responses Re: Performance problem from migrating between versions!  (Kaloyan Iliev Iliev <news1@faith.digsys.bg>)
Re: Performance problem from migrating between versions!  (Kaloyan Iliev Iliev <news1@faith.digsys.bg>)
List pgsql-performance
Tree view 
Kaloyan Iliev Iliev <news1@faith.digsys.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

pgsql-performance by date:

Previous
From: Frank Wiles
Date:
Subject: Re: Index on a function and SELECT DISTINCT
Next
From: "Andrei Bintintan"
Date:
Subject: Optimizing this count query