Re: Re: Extrordinarily Poor Performance....

Поиск
Список
Период
Сортировка
От darcy@druid.net (D'Arcy J.M. Cain)
Тема Re: Re: Extrordinarily Poor Performance....
Дата
Msg-id 20010504121028.ECA071A6B@druid.net
обсуждение исходный текст
Ответ на Re: Extrordinarily Poor Performance....  (Ryan Mahoney <ryan@paymentalliance.net>)
Список pgsql-hackers
Thus spake Ryan Mahoney
> !! I haven't ran VACUUM ANALYZE since last night.  Just ran it - 
> performance has improved significantly.  I think I am going to have to run 
> it hourly during this high traffic time.  Postmasters are still utilizing 
> about 100% of the CPU.  Is this normal?  I am considering increasing the 
> shmmax again.

Although it isn't supposed to be necessary, I find that I have to dump and
reload once in a while to keep performance hight.

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.


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

Предыдущее
От: mlw
Дата:
Сообщение: Re: Metaphone function attachment
Следующее
От: "Ken Hirsch"
Дата:
Сообщение: Re: New Linux xfs/reiser file systems