Re: How long - Vacumm full - 10 million to 90,000

From: Andrew Sullivan <ajs(at)commandprompt(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: How long - Vacumm full - 10 million to 90,000
Date: 2008-05-29 16:22:16
Message-ID: 20080529162215.GT40070@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)commandprompt(dot)com
+1 503 667 4564 x104
http://www.commandprompt.com/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Steve Crawford 2008-05-29 16:44:11 Re: How long - Vacumm full - 10 million to 90,000
Previous Message Emi Lu 2008-05-29 15:33:36 How long - Vacumm full - 10 million to 90,000