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 по дате отправления