On Tue, Apr 27, 2010 at 4:50 PM, David Wall <d.w...@computer.org> 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 (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
