Re: How to find and/or REINDEX only GiST indexes in the database?

From: Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
To: <gnanam(at)zoniac(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: How to find and/or REINDEX only GiST indexes in the database?
Date: 2011-10-28 17:40:55
Message-ID: m27h3p2evs.fsf@2ndQuadrant.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Gnanakumar" <gnanam(at)zoniac(dot)com> 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Dimitri Fontaine 2011-10-28 17:54:19 Re: pgbench-tools for Windows
Previous Message raghu ram 2011-10-27 07:12:22 Re: pgbench-tools for Windows