Postgres Pro
Downloads
Home   >   mailing lists

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

From Andrew Sullivan
Subject Re: How long - Vacumm full - 10 million to 90,000
Date
Msg-id 20080529162215.GT40070@commandprompt.com
Whole thread Raw
In response to How long - Vacumm full - 10 million to 90,000  (Emi Lu <emilu@encs.concordia.ca>)
List pgsql-sql
Tree view 
On Thu, May 29, 2008 at 11:33:36AM -0400, 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?

A really really long time.  You might actually be better off to dump
the table and restore it from that.

A

-- 
Andrew Sullivan
ajs@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/

pgsql-sql by date:

Previous
From: Emi Lu
Date:
Subject: How long - Vacumm full - 10 million to 90,000
Next
From: Steve Crawford
Date:
Subject: Re: How long - Vacumm full - 10 million to 90,000