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
Thanks a lot!
pgsql-sql by date
|Next:||From: Andrew Sullivan||Date: 2008-05-29 16:22:16|
|Subject: Re: How long - Vacumm full - 10 million to 90,000|
|Previous:||From: Bruce Momjian||Date: 2008-05-28 21:16:43|
|Subject: Re: Extremely Low performance with ODBC|