Chris Travers <chris.travers@xxxxxxxxx> wrote: > John R Pierce <pierce@xxxxxxxxxxxx> wrote: > I often find in those cases it is a choice between vacuum full > and dumpall/initdb/reload/analyze..... Way back in the 8.1 days I often found CLUSTER to be my best option -- as long as I had room enough for a second copy (without the bloat) while it was running. If I didn't have that much room the dump/initdb/restore option was almost always faster than VACUUM FULL. Personally, I would follow the restore with VACUUM FREEZE ANALYZE rather than just ANALYZE, so that the entire database didn't come due for wraparond prevention vacuums at an inopportune time. The main thing here seem to be to upgrade to a supported version (preferably 9.2 or 9.3). -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
