Postgres Pro
Downloads
Home   >   mailing lists

Re: How to check if index is valid - Mailing list pgsql-admin

From Richard Broersma
Subject Re: How to check if index is valid
Date
Msg-id 396486430803030802j4e9da60fjb533b94d4037e7a8@mail.gmail.com
Whole thread Raw
In response to How to check if index is valid  ("Vladimir Rusinov" <vladimir@greenmice.info>)
List pgsql-admin
Tree view
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.

pgsql-admin by date:

Previous
From: Michael Monnerie
Date:
Subject: Re: Power outage borked things (8.1.10)...
Next
From: Nuwan Liyanage
Date:
Subject: Delete from base table and not partitions