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