Re: Index bloat, reindex weekly, suggestions etc?

On Fri, Oct 17, 2008 at 10:35 AM, Kevin Grittner
<Kevin.Grittner@wicourts.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