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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
