Re: Slow vacuum performance

Поиск
Список
Период
Сортировка
От Dennis Bjorklund
Тема Re: Slow vacuum performance
Дата
Msg-id Pine.LNX.4.44.0406180629120.8193-100000@zigo.dhs.org
обсуждение исходный текст
Ответ на Slow vacuum performance  (Patrick Hatcher <PHatcher@macys.com>)
Список pgsql-performance
On Thu, 17 Jun 2004, Patrick Hatcher wrote:

> I have 6 million row table that I vacuum full analyze each night.  The time
> seems to be streching out further and further as I add more rows.  I read

You could try to run normal (non full) vacuum every hour or so. If you do
normal vacuum often enough you probably don't need to run vacuum full at
all.

--
/Dennis Björklund


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

Предыдущее
От: Patrick Hatcher
Дата:
Сообщение: Slow vacuum performance
Следующее
От: Andrew McMillan
Дата:
Сообщение: Re: Slow vacuum performance