Re: Performance problem from migrating between versions!

Поиск
Список
Период
Сортировка
От Kaloyan Iliev Iliev
Тема Re: Performance problem from migrating between versions!
Дата
Msg-id 41EC0A86.5090001@faith.digsys.bg
обсуждение исходный текст
Ответ на Re: Performance problem from migrating between versions!  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Performance problem from migrating between versions!  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Tom Lane wrote:

>I wouldn't recommend turning off hashagg as a permanent solution, it
>was just a quickie to verify my suspicion of where the memory was going.
>
>
>

Hi,

How to understant the upper sentence? I shouldn't turn "hashagg" off
permanently for this query or for the entire database. For now I turn it
off for this query, so it can work. If I shouldn't, then what should I
do? Will ANALYZE resove this?

Kaloyan Iliev

В списке pgsql-performance по дате отправления:

Предыдущее
От: PFC
Дата:
Сообщение: Re: Index on a function and SELECT DISTINCT
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Performance problem from migrating between versions!