Re: performance drop on 8.2.4, reverting to 8.1.4

Поиск
Список
Период
Сортировка
От Liviu Ionescu
Тема Re: performance drop on 8.2.4, reverting to 8.1.4
Дата
Msg-id 009501c79951$24596eb0$653e10ac@ilgvaio
обсуждение исходный текст
Ответ на Re: performance drop on 8.2.4, reverting to 8.1.4  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
Список pgsql-performance
> > it helped, the new version of the query takes 2303 ms on both 8.1.4
> > and 8.2.4.
>
> And the old one?

slightly shorter, 2204 ms.

as a subjective perception, the entire application is slightly slower on 8.2.4, probably there are many queries that
weremanually tunned for 7.x/8.1.x and now need rewriting, which is not really what I expected from an upgrade. 


Liviu


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

Предыдущее
От: "Steinar H. Gunderson"
Дата:
Сообщение: Re: performance drop on 8.2.4, reverting to 8.1.4
Следующее
От: Mark Lewis
Дата:
Сообщение: Re: Ever Increasing IOWAIT