Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 5299A2E0084 for ; Mon, 3 Mar 2008 12:02:19 -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 96176-02 for ; Mon, 3 Mar 2008 12:02:13 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from gv-out-0910.google.com (gv-out-0910.google.com [216.239.58.186]) by postgresql.org (Postfix) with ESMTP id B46442E0080 for ; Mon, 3 Mar 2008 12:02:12 -0400 (AST) Received: by gv-out-0910.google.com with SMTP id y18so96848gvf.7 for ; Mon, 03 Mar 2008 08:02:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=EpO3I1xOAoKHq397JUkyri7Df+uVDwDTQgJG/rRPGCs=; b=PtJOon8+k6alv5kAGFhSs10kgRv/uDWgANrfVZvwBnJDk6us+a79kvpoebZlA7eSX6/ZsmyzsXqqnr6q97XdNekWwPyy+KDumYv+fjfMB2sDU3SYZY6er1eXs3T3Fk6nz6oGXlhEYr2kV7QYnwPR5R5yxDU7JLSE28RpBw99WPo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=N6COhcAESM7+cbM60aLHJm9qer0su0SPaTkuQHiOM3dSkU3FpnBRmw5dPK1xsCNylDzkz1hYdE/YePvjdnTE4uDf5JKTOHmUoYM0Mkaq1UFx0wmnn4qlOAWQllmK3hdSOaSzc+L2vEg8v8h+TDbbLq7lB6jYPw5k9GBZd8wNsH8= Received: by 10.142.212.19 with SMTP id k19mr79614wfg.86.1204560130541; Mon, 03 Mar 2008 08:02:10 -0800 (PST) Received: by 10.142.188.12 with HTTP; Mon, 3 Mar 2008 08:02:10 -0800 (PST) Message-ID: <396486430803030802j4e9da60fjb533b94d4037e7a8@mail.gmail.com> Date: Mon, 3 Mar 2008 08:02:10 -0800 From: "Richard Broersma" To: "Vladimir Rusinov" Subject: Re: How to check if index is valid Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_20255_28319058.1204560130509" References: 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/12 X-Sequence-Number: 28495 ------=_Part_20255_28319058.1204560130509 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On Mon, Mar 3, 2008 at 3:55 AM, Vladimir Rusinov 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. ------=_Part_20255_28319058.1204560130509 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
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.
------=_Part_20255_28319058.1204560130509--