Re: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps
Дата
Msg-id 3515.1118695503@sss.pgh.pa.us
обсуждение исходный текст
Ответ на PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps  (Együd Csaba <csegyud@vnet.hu>)
Ответы Re: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM  (Együd Csaba <csegyud@vnet.hu>)
Список pgsql-general
=?iso-8859-2?Q?Egy=FCd_Csaba?= <csegyud@vnet.hu> writes:
> The critical tables are vacuum analyzed in every hour.

Evidently that's not often enough.  Or it could be that your
FSM settings aren't large enough?

            regards, tom lane

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

Предыдущее
От: David Mitchell
Дата:
Сообщение: Index problem
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps