Re: postgres: 100% CPU utilization

Список
Период
Сортировка
От Ron
Тема Re: postgres: 100% CPU utilization
Дата
Msg-id E1Hg07i-0004wn-Sr@elasmtp-dupuy.atl.sa.earthlink.net
обсуждение исходный текст
Ответ на Re: postgres: 100% CPU utilization  (Mario Weilguni)
Ответы Re: postgres: 100% CPU utilization  ("Sergey Tsukinovsky")
Список pgsql-performance
Дерево обсуждения
postgres: 100% CPU utilization  ("Sergey Tsukinovsky", )
 Re: postgres: 100% CPU utilization  (Tom Lane, )
 Re: postgres: 100% CPU utilization  (Andreas Tille, )
 Re: postgres: 100% CPU utilization  (Mario Weilguni, )
  Re: postgres: 100% CPU utilization  (Ron, )
   Re: postgres: 100% CPU utilization  ("Sergey Tsukinovsky", )
    Re: postgres: 100% CPU utilization  (Scott Marlowe, )
    Re: postgres: 100% CPU utilization  (Mark Kirkwood, )
 Re: postgres: 100% CPU utilization  (Scott Marlowe, )
  Re: postgres: 100% CPU utilization  (Vivek Khera, )
   Re: postgres: 100% CPU utilization  (Scott Marlowe, )
    Re: postgres: 100% CPU utilization  (Greg Smith, )
  Re: postgres: 100% CPU utilization  (Mark Kirkwood, )
At 04:53 AM 4/23/2007, Mario Weilguni wrote:
>Am Donnerstag, 19. April 2007 schrieb Sergey Tsukinovsky:
> > 2. What would be the recommended set of parameters to tune up in order
> > to improve the performance over the time, instead of considering an
> > option to vacuum every 30 minutes or so?
> >
> > 3. Is it safe to run 'vacuum' as frequently as every 15-30 minutes?
>No problem.
>
> >
> > 4. Suggestions?
>Do yourself a favor and upgrade at least to 8.1.x and use autovacuum.
In fact, I'll go one step further and say that pg improves so much
from release to release that everyone should make superhuman efforts
to always be running the latest stable release.

Even the differences between 8.1.x and 8.2.x are worth it.

(and the fewer and more modern the releases "out in the wild", the
easier community support is)
Cheers,
Ron Peacetree


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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: postgres: 100% CPU utilization
Следующее
От: Mark Kirkwood
Дата:
Сообщение: Re: postgres: 100% CPU utilization