On Tue, Nov 9, 2010 at 4:26 AM, AI Rumman <rummandba@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
