On Fri, Oct 17, 2008 at 10:35 AM, Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
