Re: After how many updates should a vacuum be performed?

Поиск
Список
Период
Сортировка
От Ellen Cyran
Тема Re: After how many updates should a vacuum be performed?
Дата
Msg-id 45083274.902@urban.csuohio.edu
обсуждение исходный текст
Ответ на Re: After how many updates should a vacuum be performed?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: After how many updates should a vacuum be performed?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
No, I mean vacuum analyze.  I'll vacuum verbose and see about adjusting
the fsm.  Thanks.

Tom Lane wrote:

> Ellen Cyran <ellen@urban.csuohio.edu> writes:
>
>>We have a database that periodically we perform large updates, around
>>a million records, after that the vacuum will run for 12 hours without
>>completing.  After that, I typically remove the 2 indexes and 1
>>constraint on the largest table, 7 million records, and the vacuum will
>>complete in a couple of hours and the indexes can be recreated in a half
>>hour.
>
>
> By "vacuum" do you mean VACUUM FULL?  My advice is not to use that,
> just plain VACUUM.  Don't forget to make sure your FSM is large enough,
> too.
>
>             regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: After how many updates should a vacuum be performed?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: COPY FROM command v8.1.4