On Tue, Nov 9, 2010 at 1:51 PM, Igor Neyman <iney...@perceptron.com> wrote:
> > -----Original Message----- > > From: AI Rumman [mailto:rumman...@gmail.com] > > Sent: Tuesday, November 09, 2010 3:26 AM > > To: pgsql-general General > > Subject: REINDEX requirement? > > > > How do I know that index require REINDEX? > > > > > > Look at the results of pgstatindex(...) function for specific index. > 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
