Re: How to monitor resources on Linux.

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: How to monitor resources on Linux.
Дата
Msg-id 20070828195554.GB1683@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на Re: How to monitor resources on Linux.  (John R Allgood <jallgood@the-allgoods.net>)
Ответы Re: How to monitor resources on Linux.  (John R Allgood <jallgood@the-allgoods.net>)
Re: How to monitor resources on Linux.  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-admin
On Tue, Aug 28, 2007 at 03:40:03PM -0400, John R Allgood wrote:
> lot of activity as compared to the other databases. We run VACUUM at
> midday VACUUM FULL at night, VACUUM ANALYZE on weekends.

If you are running VACUUM often enough, then you should _never_ need
VACUUM FULL.  And weekly VACUUM ANALYSE is probably too infrequent.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
"The year's penultimate month" is not in truth a good way of saying
November.
        --H.W. Fowler

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

Предыдущее
От: John R Allgood
Дата:
Сообщение: Re: How to monitor resources on Linux.
Следующее
От: John R Allgood
Дата:
Сообщение: Re: How to monitor resources on Linux.