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
Дата:
Сообщение: Re: Upgraded to 8.2.3 --- still having performance issues
От: Bruno Wolff III
Дата:
Сообщение: Re: Two hard drives --- what to do with them?