How long - Vacumm full - 10 million to 90,000

Поиск
Список
Период
Сортировка
От Emi Lu
Тема How long - Vacumm full - 10 million to 90,000
Дата
Msg-id 483ECCD0.5020309@encs.concordia.ca
обсуждение исходный текст
Ответы Re: How long - Vacumm full - 10 million to 90,000  (Andrew Sullivan <ajs@commandprompt.com>)
Re: How long - Vacumm full - 10 million to 90,000  (Steve Crawford <scrawford@pinpointresearch.com>)
Список pgsql-sql
Good morning,

A question about VACUUM FULL. The docs say:

VACUUM FULL is recommended for cases where you know you have deleted the 
majority of rows in a table, so that the steady-state size of the table 
can be shrunk substantially with VACUUM FULL's more aggressive approach. 
Use plain VACUUM, not VACUUM FULL, for routine vacuuming for space recovery.

I have a table from around 10 million to 90,000, after deletion, I tried 
to use vacuum full, but it seems that it takes forever to finish. Could 
anyone tell me how long it will take to finish the Recovering disk space 
please?

Thanks a lot!


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Extremely Low performance with ODBC
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: How long - Vacumm full - 10 million to 90,000