Re: REINDEX requirement? - Mailing list pgsql-general

From Igor Neyman
Subject Re: REINDEX requirement?
Date
Msg-id F4C27E77F7A33E4CA98C19A9DC6722A206BE88F5@EXCHANGE.corp.perceptron.com
Whole thread Raw
In response to REINDEX requirement?  (AI Rumman <rummandba@gmail.com>)
Responses Re: REINDEX requirement?  (Robert Treat <rob@xzilla.net>)
List pgsql-general

> -----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.

Regards,
Igor Neyman

pgsql-general by date:

Previous
From: Sandeep Srinivasa
Date:
Subject: Re: Why facebook used mysql ?
Next
From: Ralph Smith
Date:
Subject: Re: I guess I'm missing something here WRT FOUND