Postgres Pro
Downloads
Home   >   mailing lists

Re: REINDEX requirement? - Mailing list pgsql-general

From Robert Treat
Subject Re: REINDEX requirement?
Date
Msg-id AANLkTim8qY8qAJSLBz1upCB3=P6bw2UCeFCJ1YBWO8eN@mail.gmail.com
Whole thread Raw
In response to Re: REINDEX requirement?  ("Igor Neyman" <ineyman@perceptron.com>)
Responses Re: REINDEX requirement?  ("Marc Mamin" <M.Mamin@intershop.de>)
List pgsql-general
Tree view
On Tue, Nov 9, 2010 at 1:51 PM, Igor Neyman <ineyman@perceptron.com> wrote:
> -----Original Message-----
> From: AI Rumman [mailto:rummandba@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

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: Why facebook used mysql ?
Next
From: "Filonenko Michael"
Date:
Subject: NOTIFY/LISTEN why is not a callback as notice processing.