Re: Performance problem from migrating between versions!

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Performance problem from migrating between versions!
Дата
Msg-id 2253.1105978380@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Performance problem from migrating between versions!  (Kaloyan Iliev Iliev <news1@faith.digsys.bg>)
Ответы Re: Performance problem from migrating between versions!
Re: Performance problem from migrating between versions!
Список pgsql-performance
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 по дате отправления:

Предыдущее
От: Frank Wiles
Дата:
Сообщение: Re: Index on a function and SELECT DISTINCT
Следующее
От: "Andrei Bintintan"
Дата:
Сообщение: Optimizing this count query