Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to check if index is valid

How to check if index is valid

From
"Vladimir Rusinov"
Date:
Hello!

How can I check if all indexes in my database is valid, how to show the invalid ones (and rebuild them)?
Any quick solutions?

Thanks.

--
Vladimir Rusinov
Voronezh, Russia

Re: How to check if index is valid

From
"Richard Broersma"
Date:
On Mon, Mar 3, 2008 at 3:55 AM, Vladimir Rusinov <vladimir@greenmice.info> wrote:
 
How can I check if all indexes in my database is valid, how to show the invalid ones (and rebuild them)?
Any quick solutions?
 
How do you define whether and index is valid or invalid?

--
Regards,
Richard Broersma Jr.