Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 6049CB5DCE9 for ; Fri, 28 Oct 2011 14:41:25 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 38284-04 for ; Fri, 28 Oct 2011 17:41:18 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from acidenitrix.villemain.org (acidenitrix.villemain.org [91.121.90.165]) by mail.postgresql.org (Postfix) with ESMTP id C5900B5DD40 for ; Fri, 28 Oct 2011 14:41:04 -0300 (ADT) Received: from [89.157.192.174] (helo=DimIMac.local) by acidenitrix.villemain.org with esmtpsa (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.69) (envelope-from ) id 1RJqQQ-0000E0-2N; Fri, 28 Oct 2011 19:41:02 +0200 Received: by DimIMac.local (Postfix, from userid 501) id 923E82D6AE7E; Fri, 28 Oct 2011 19:40:55 +0200 (CEST) From: Dimitri Fontaine To: Cc: Subject: Re: How to find and/or REINDEX only GiST indexes in the database? Organization: 2ndQuadrant References: <008201cc88dd$0208c1a0$061a44e0$@com> User-Mail-Address: dimitri@2ndQuadrant.fr Date: Fri, 28 Oct 2011 19:40:55 +0200 In-Reply-To: <008201cc88dd$0208c1a0$061a44e0$@com> (Gnanakumar's message of "Wed, 12 Oct 2011 18:16:45 +0530") Message-ID: User-Agent: Gnus/5.110018 (No Gnus v0.18) Emacs/24.0.90 (darwin) MIME-Version: 1.0 Content-Type: text/plain X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201110/129 X-Sequence-Number: 38581 "Gnanakumar" writes: > My question is, how do I find out or REINDEX *only* GiST indexes in the > database? Is there a single syntax/command that does this? You might find this article useful: http://tapoueh.org/blog/2010/08/05-querying-the-catalog-to-plan-an-upgrade.html Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support