Re: How to check if index is valid

From: "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com>
To: "Vladimir Rusinov" <vladimir(at)greenmice(dot)info>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to check if index is valid
Date: 2008-03-03 16:02:10
Message-ID: 396486430803030802j4e9da60fjb533b94d4037e7a8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Mar 3, 2008 at 3:55 AM, Vladimir Rusinov <vladimir(at)greenmice(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Nuwan Liyanage 2008-03-03 16:21:29 Delete from base table and not partitions
Previous Message Michael Monnerie 2008-03-03 14:40:02 Re: Power outage borked things (8.1.10)...