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

Поиск
Список
Период
Сортировка
Искать
От
Carlos Moreno
Тема
Re: Upgraded to 8.2.3 --- still having performance issues
Дата
Msg-id
45E5CBE5.2000009@mochima.com
Ответ на
Список
Дерево обсуждения
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 Dennis Bjorklund <db@zigo.dhs.org>
Re: Upgraded to 8.2.3 --- still having performance issues Tom Lane <tgl@sss.pgh.pa.us>
Re: Upgraded to 8.2.3 --- still having performance issues Carlos Moreno <carlos.moreno@mochima.com>
Re: 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 Rodrigo Gonzalez <rjgonzale@gmail.com>
Re: 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 Carlos Moreno <moreno_pg@mochima.com>
Tom Lane wrote:

>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 ...
>  
>

I did.

I didn't think it would be necessary, but being paranoid as I am, I figured
let's do it just in case.

After a few hours of operation, I did a vacuumdb -z  also.  But it seems to
continue downhill   :-(

Thanks,

Carlos
--

В списке pgsql-performance по дате отправления
От: hatman
Дата:
Сообщение: performances with Pentium D
От: Ben Trewern
Дата:
FAQ