Re: Index bloat, reindex weekly, suggestions etc?

On Fri, Oct 17, 2008 at 10:35 AM, Kevin Grittner
<Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> As already pointed out, that's a lot of free space. You don't use
> VACUUM FULL on this database, do you? That would keep the data
> relatively tight but seriously bloat indexes, which is consistent with
> your symptoms. VACUUM FULL should not be used routinely, it is
> basically for recovery from serious heap bloat when you don't have
> space for another copy of the data, and it should usually be followed
> by a REINDEX to clean up the index bloat it causes.

Interesting, I do run:

"# vacuum and analyze each db before dumping
psql $DB -c 'vacuum analyze verbose'""

every night before I dump, is that causing some issues that I'm not aware of?

Tory