After how many updates should a vacuum be performed?

Поиск
Список
Период
Сортировка
От Ellen Cyran
Тема After how many updates should a vacuum be performed?
Дата
Msg-id 45082C83.5040206@urban.csuohio.edu
обсуждение исходный текст
Ответы Re: After how many updates should a vacuum be performed?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
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.

After how many updates should a vacuum be performed?  Do indexes need to
be recreated periodically?  Would auto vacuuming help in this case?  Any
suggestions on tuning?

The database is in PostgreSQL 8.0.7.

Thanks.

Ellen



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

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