How long - Vacumm full - 10 million to 90,000 - Mailing list pgsql-sql

From Emi Lu
Subject How long - Vacumm full - 10 million to 90,000
Date
Msg-id 483ECCD0.5020309@encs.concordia.ca
Whole thread Raw
Responses Re: How long - Vacumm full - 10 million to 90,000
Re: How long - Vacumm full - 10 million to 90,000
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Extremely Low performance with ODBC
Next
From: Andrew Sullivan
Date:
Subject: Re: How long - Vacumm full - 10 million to 90,000