Re: auto-vacuum vs. full table update

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: auto-vacuum vs. full table update
Дата
Msg-id 4F99658B0200002500047411@gw.wicourts.gov
обсуждение исходный текст
Ответ на auto-vacuum vs. full table update  (Craig James <cjames@emolecules.com>)
Список pgsql-performance
Craig James <cjames@emolecules.com> wrote:
> An update to our system means I'm going to be rewriting every row
> of some large tables (20 million rows by 15 columns).  In a
> situation like this, can auto-vacuum take care of it, or should I
> plan on vacuum-full/reindex to clean up?
>
> This is 8.4.4.

If there is any way for you to update in "chunks", with a vacuum
after each chunk, that will prevent the extreme bloat.

-Kevin

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: query optimization
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: query optimization