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

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@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