Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id BD69D2E005C for ; Mon, 3 Mar 2008 08:02:35 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 01527-01 for ; Mon, 3 Mar 2008 08:02:11 -0400 (AST) X-Greylist: delayed 00:06:39.370301 by SQLgrey-1.7.5 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.234]) by postgresql.org (Postfix) with ESMTP id 0F0492E004A for ; Mon, 3 Mar 2008 08:02:17 -0400 (AST) Received: by wx-out-0506.google.com with SMTP id r21so5733479wxc.28 for ; Mon, 03 Mar 2008 04:02:16 -0800 (PST) Received: by 10.70.91.16 with SMTP id o16mr12253236wxb.38.1204545335894; Mon, 03 Mar 2008 03:55:35 -0800 (PST) Received: by 10.70.34.20 with HTTP; Mon, 3 Mar 2008 03:55:35 -0800 (PST) Message-ID: Date: Mon, 3 Mar 2008 14:55:35 +0300 From: "Vladimir Rusinov" To: pgsql-admin@postgresql.org Subject: How to check if index is valid MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_5047_8501748.1204545335877" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200803/10 X-Sequence-Number: 28493 ------=_Part_5047_8501748.1204545335877 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ------=_Part_5047_8501748.1204545335877 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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
------=_Part_5047_8501748.1204545335877--