Re: Performance problem from migrating between versions!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kaloyan Iliev Iliev <news1(at)faith(dot)digsys(dot)bg>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance problem from migrating between versions!
Date: 2005-01-17 16:13:00
Message-ID: 2253.1105978380@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andrei Bintintan 2005-01-17 16:58:09 Optimizing this count query
Previous Message Frank Wiles 2005-01-17 16:09:42 Re: Index on a function and SELECT DISTINCT