How to check if index is valid

From: "Vladimir Rusinov" <vladimir(at)greenmice(dot)info>
To: pgsql-admin(at)postgresql(dot)org
Subject: How to check if index is valid
Date: 2008-03-03 11:55:35
Message-ID: f6fdfb550803030355x18478426sa4134ad26e521ea4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Monnerie 2008-03-03 14:40:02 Re: Power outage borked things (8.1.10)...
Previous Message Bruce Momjian 2008-03-02 22:21:56 Re: Latest postgres stable version