Re: Upgraded to 8.2.3 --- still having performance issues

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Upgraded to 8.2.3 --- still having performance issues
Дата
Msg-id 5279.1172683250@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Upgraded to 8.2.3 --- still having performance issues  (Carlos Moreno <moreno_pg@mochima.com>)
Ответы Re: Upgraded to 8.2.3 --- still having performance issues
Re: Upgraded to 8.2.3 --- still having performance issues
Список pgsql-performance
Carlos Moreno <moreno_pg@mochima.com> writes:
> I would have expected a mind-blowing increase in responsiveness and
> overall performance.  However, that's not the case --- if I didn't know
> better, I'd probably tend to say that it is indeed the opposite
> (performance seems to have deteriorated)

Did you remember to re-ANALYZE everything after loading up the new
database?  That's a frequent gotcha ...

            regards, tom lane

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

Предыдущее
От: Carlos Moreno
Дата:
Сообщение: Upgraded to 8.2.3 --- still having performance issues
Следующее
От: Carlos Moreno
Дата:
Сообщение: Re: Upgraded to 8.2.3 --- still having performance issues