Re: delete/vacuum not freeing disk space

In article <20011006165604(dot)72133(dot)qmail(at)web20005(dot)mail(dot)yahoo(dot)com>,
Joshua Franklin wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

vacuum does not reclame space in indexes, if you use a command called
reindex to recreate the indexes it may reclame space. It needs space
to write the new index's though. Reindex should be run in sigle user
mode only, per the docs.

marc