On Tue, Apr 27, 2010 at 4:50 PM, David Wall <[email protected]> wrote: > It seems my options are 1) VACUUM FULL with a reindex_db; or 2) backup, then > restore. >
I'd go with the backup+restore. The other option is to to a trivial ALTER to one of your fields which causes the table to be rewritten. Basically, anything is faster than a VACUUM FULL in my experience. -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
