Re: When do I Vacuum ?

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: When do I Vacuum ?
Дата
Msg-id m3oflcb43m.fsf@belphigor.mcnaught.org
обсуждение исходный текст
Ответ на Re: When do I Vacuum ?  ("Steve Brett" <steve.brett@e-mis.com>)
Список pgsql-general
"Steve Brett" <steve.brett@e-mis.com> writes:

> could someone please post an answer, even if it's just a pointer to
> somewhere else ... please ....

Sorry, I just got your message--looks like the list got hung up for a
little while.

The nice thing about VACUUM is that if you're running it "too often"
it won't have very much work to do so it'll complete very quickly.  The
only thing to watch out for is lock contention between VACUUM and
"real work" (which is why Bruce suggests running it at quiet times).

So once an hour isn't going to hurt anything most likely, though it is
probably overkill for your current situation.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

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

Предыдущее
От: Doug McNaught
Дата:
Сообщение: Re: [BASIC FEATURES] stored procedures in Postgresql ?
Следующее
От: Herb Blacker
Дата:
Сообщение: DBVisualizer