>>> "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
In response to
pgsql-performance by date
|Next:||From: Greg Smith||Date: 2008-10-17 18:15:51|
|Subject: Re: Annoying Reply-To|
|Previous:||From: Tory M Blue||Date: 2008-10-17 17:48:07|
|Subject: Re: Index bloat, reindex weekly, suggestions etc?|