Re: How to check if index is valid

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: How to check if index is valid
From: "Richard Broersma" <richard.broersma@xxxxxxxxx>
Date: Mon, 3 Mar 2008 08:02:10 -0800
Cc: pgsql-admin@xxxxxxxxxxxxxx
In-reply-to: <f6fdfb550803030355x18478426sa4134ad26e521ea4@xxxxxxxxxxxxxx>
References: <f6fdfb550803030355x18478426sa4134ad26e521ea4@xxxxxxxxxxxxxx>
Sender: pgsql-admin-owner@xxxxxxxxxxxxxx

On Mon, Mar 3, 2008 at 3:55 AM, Vladimir Rusinov <vladimir@xxxxxxxxxxxxxx> 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.

References:
- How to check if index is valid
  - From: Vladimir Rusinov

Prev by Date: Re: Power outage borked things (8.1.10)...
Next by Date: Delete from base table and not partitions
Previous by thread: How to check if index is valid
Next by thread: Delete from base table and not partitions
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux