On Tue, Nov 9, 2010 at 4:26 AM, AI Rumman <rummandba@gmail.com> wrote:
> How do I know that index require REINDEX?
Well, the REINDEX page:
<http://www.postgresql.org/docs/current/static/sql-reindex.html>
gives a few examples of why you might need to reindex. I think the
most common reason would probably be due to index bloat. See
<http://wiki.postgresql.org/wiki/Index_Maintenance>
under "Index Bloat" for links to some handy queries to see whether
your tables and/or indexes suffer bloat.
Josh