delete/vacuum not freeing disk space

From: Joshua Franklin <joshuadfranklin(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: delete/vacuum not freeing disk space
Date: 2001-10-06 16:56:04
Message-ID: 20011006165604.72133.qmail@web20005.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I've got a large database that's getting too big. I
checked with the users and deleted approximately 1/6th
of the records (we have archived backups) and then ran
a VACUUM, which took a really long time to complete
(several days). But, the disk space usage doesn't seem
to have changed. Do I need to VACUUM twice or
something? Should it be faster the second time?

Thanks.

__________________________________________________
Do You Yahoo!?
NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Russ McBride 2001-10-06 20:27:00 Mac OS X installation web page
Previous Message Pedro Fonseca 2001-10-05 23:47:24 Re: Authorization problem