Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
How long - Vacumm full - 10 million to 90,000
- From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
- To: PostgreSQL-SQL <pgsql-sql(at)postgresql(dot)org>
- Subject: How long - Vacumm full - 10 million to 90,000
- Date: Thu, 29 May 2008 11:33:36 -0400
- Message-id: <483ECCD0(dot)5020309(at)encs(dot)concordia(dot)ca>
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!
- Follow-Ups:
- Re: How long - Vacumm full - 10 million to 90,000
- From: Steve Crawford
- Re: How long - Vacumm full - 10 million to 90,000
- From: Andrew Sullivan
- Re: How long - Vacumm full - 10 million to 90,000
- Prev by Date: Re: Extremely Low performance with ODBC
- Next by Date: Re: How long - Vacumm full - 10 million to 90,000
- Previous by thread: UPDATE with table join
- Next by thread: Re: How long - Vacumm full - 10 million to 90,000
- Indexes: