Look at the results of pgstatindex(...) function for specific index.> -----Original Message-----
> From: AI Rumman [mailto:rummandba@xxxxxxxxx]
> Sent: Tuesday, November 09, 2010 3:26 AM
> To: pgsql-general General
> Subject: REINDEX requirement?
>
> How do I know that index require REINDEX?
>
>
It's part of pgstattupple contrib module - read it up in the docs.
If you are looking for a "poor mans" tool, we have a script that will output numbers on table/index bloat. It's not entirely accurate (patches welcome), but usually good enough to highlight the problems. See http://labs.omniti.com/labs/pgtreats/log/trunk/tools/pg_bloat_report.pl
Robert Treat
play: http://www.xzilla.net
work: http://www.omniti.com/is/hiring
