On Tue, Apr 27, 2010 at 4:50 PM, David Wall <d.wall@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.