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