Re: Slow after VACUUM, fast after DROP-CREATE INDEX

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема Re: Slow after VACUUM, fast after DROP-CREATE INDEX
Дата
Msg-id 411410CA.9070605@bigfoot.com
обсуждение исходный текст
Ответ на Re: Slow after VACUUM, fast after DROP-CREATE INDEX  ("Scott Marlowe" <smarlowe@qwest.net>)
Список pgsql-general
Scott Marlowe wrote:
> Unfortunately, the administrative overhead in 7.1.3 is noticeably higher
> than it is in 7.4.  The overhead should be lowered even more in 8.0 with
> the integration of the autovacuum daemon into the backend process.

May be the autovacuum will be integrated in the version 8.1 and not in the
version 8.0. However the pg_autovacuum is not enough, I suggest at least
once a day perform a vacuum full and a reindex for tables eavily updated.


Regards
Gaetano Mendola

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

Предыдущее
От: Markus Bertheau
Дата:
Сообщение: Re: probelm migrating from 7.3.4 to 7.42
Следующее
От: Gaetano Mendola
Дата:
Сообщение: Re: Postgres and Tools Intro?