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