>>> "Tory M Blue" <tmblue(at)gmail(dot)com> wrote:
> psql $DB -c 'vacuum analyze verbose'""
That's fine; you're not using the FULL option.
> every night before I dump
Another thing that could cause bloat is a long-running transaction.
Check for that. If your database is being updated during a pg_dump or
pg_dumpall, that would count as a long-running transaction. You might
possibly want to look at going to the PITR backup technique for your
regular backups.
-Kevin