>>> "Tory M Blue" <tmblue@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
