In article <[EMAIL PROTECTED]>, 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
