Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Thu, 29 May 2008 12:22:16 -0400
  • Message-id: <20080529162215.GT40070@commandprompt.com> <text/plain>

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/



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group