On Tue, Dec 30, 2008 at 4:05 AM, Laszlo Nagy <gandalf@xxxxxxxxxxxx> wrote: > We have serveral table where the index size is much bigger than the table > size. You'll usually get index bloat in roughly the same measure that you get table bloat. If you always (auto)vacuum regularly, then the amount of bloat in your indexes probably reflects the amount of bloat that your tables typically accumulate between vacuums, so reindexing won't help much. The indexes will just re-bloat back to about the same point over the next vacuum cycle or two. On the other hand, if your table has shrunk considerably, or if you've just removed a lot of bloat by vacuuming, REINDEX is often warranted. It would be nice if the system could automatically notice and correct situations that currently require VACUUM FULL or REINDEX, but it doesn't. ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
