Re: REINDEX requirement?

From: "Igor Neyman" <ineyman(at)perceptron(dot)com>
To: "AI Rumman" <rummandba(at)gmail(dot)com>, "pgsql-general General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: REINDEX requirement?
Date: 2010-11-09 18:51:36
Message-ID: F4C27E77F7A33E4CA98C19A9DC6722A206BE88F5@EXCHANGE.corp.perceptron.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> -----Original Message-----
> From: AI Rumman [mailto:rummandba(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ralph Smith 2010-11-09 18:58:28 Re: I guess I'm missing something here WRT FOUND
Previous Message Sandeep Srinivasa 2010-11-09 18:36:08 Re: Why facebook used mysql ?