Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 3A557B5DBDF for ; Wed, 12 Oct 2011 10:00:03 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 38233-06 for ; Wed, 12 Oct 2011 12:59:56 +0000 (UTC) X-Greylist: delayed 00:05:56.30476 by SQLgrey-1.8.0-rc2 Received: from rs133.luxsci.com (rs133.luxsci.com [72.32.115.26]) by mail.postgresql.org (Postfix) with ESMTP id 453AFB5DBDA for ; Wed, 12 Oct 2011 09:59:56 -0300 (ADT) Received: from GNANAM (NSG-Static-233.156.72.182.airtel.in [182.72.156.233] (may be forged)) (authenticated bits=0) by rs133.luxsci.com (8.13.8/8.13.8) with ESMTP id p9CCroBT018364; Wed, 12 Oct 2011 07:53:57 -0500 Reply-To: From: "Gnanakumar" To: Subject: How to find and/or REINDEX only GiST indexes in the database? Date: Wed, 12 Oct 2011 18:16:45 +0530 Organization: Zoniac Software Private Limited Message-ID: <008201cc88dd$0208c1a0$061a44e0$@com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: AcyI3P7PZvESIzwPQMWJQTdM2u2jfw== Content-Language: en-us 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/57 X-Sequence-Number: 38509 Hi, We're planning to upgrade our Production server from PostgreSQL v8.2.3 to the latest version in 8.2 series, that is v8.2.22. In 8.2.11 Release Notes here http://www.postgresql.org/docs/current/interactive/release-8-2-11.html, it's been mentioned that: "Also, if you were running a previous 8.2.X release, it is recommended to REINDEX all GiST indexes after the upgrade." 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? Regards, Gnanam