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)
Ответы Re: Upgraded to 8.2.3 --- still having performance issues  (Carlos Moreno)
Re: Upgraded to 8.2.3 --- still having performance issues  (Carlos Moreno)
Список pgsql-performance
Дерево обсуждения
Upgraded to 8.2.3 --- still having performance issues  (Carlos Moreno, )
 Re: Upgraded to 8.2.3 --- still having performance issues  (Tom Lane, )
  Re: Upgraded to 8.2.3 --- still having performance issues  (Carlos Moreno, )
   Re: Upgraded to 8.2.3 --- still having performance issues  (Rodrigo Gonzalez, )
    Re: Upgraded to 8.2.3 --- still having performance issues  (Carlos Moreno, )
     Re: Upgraded to 8.2.3 --- still having performance issues  (Carlos Moreno, )
  Re: Upgraded to 8.2.3 --- still having performance issues  (Carlos Moreno, )
 Re: Upgraded to 8.2.3 --- still having performance issues  (Dennis Bjorklund, )
Carlos Moreno <> 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