Re: Is there a reason _not_ to vacuum continuously?

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Is there a reason _not_ to vacuum continuously?
Дата
Msg-id 003f01c37dbe$4b6f9d10$2800a8c0@mars
обсуждение исходный текст
Ответ на Re: Is there a reason _not_ to vacuum continuously?  ("Oliver Scheit" <oliver.scheit@REALGARANT.DE>)
Список pgsql-performance
> 3) using PG 7.3 or less, you will also need to REINDEX these
>    tables+indexes often (daily?).   This issue will go away
>    in 7.4, which should make you an early adopter of 7.4.

Try monthly maybe.

> Is this true? Haven't heard of this before.
> If so, how can this be managed in a cronjob?
> For the hourly VACUUM there's vacuumdb, but is
> there somehting similar like reindexdb ?

Yes, there is reindexdb :)

Chris


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

Предыдущее
От: "Oliver Scheit"
Дата:
Сообщение: Re: Is there a reason _not_ to vacuum continuously?
Следующее
От: "Oliver Scheit"
Дата:
Сообщение: Re: Is there a reason _not_ to vacuum continuously?