Emi Lu wrote:
> ...
> 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?
No. Probably a looooonnnnnng time.
In a case like this where you are retaining less than 1% of your records
you are likely to see far, far faster results using CLUSTER - with the
added advantage that CLUSTER will create fresh indexes for you, too.
Alternately, you can:
CREATE TABLE xxx as SELECT * from yourtable;
TRUNCATE yourtable;
INSERT into yourtable SELECT * from xxx;
DROP TABLE xxx;
If you are so close to out-of-space on your disk that you don't have the
room those 90,000 records will require, you may have to dump/restore
using another machine.
Cheers,
Steve
