Postgres Pro
Downloads
Home   >   mailing lists

Re: How to find and/or REINDEX only GiST indexes in the database? - Mailing list pgsql-admin

From Dimitri Fontaine
Subject Re: How to find and/or REINDEX only GiST indexes in the database?
Date
Msg-id m27h3p2evs.fsf@2ndQuadrant.fr
Whole thread Raw
In response to How to find and/or REINDEX only GiST indexes in the database?  ("Gnanakumar" <gnanam@zoniac.com>)
List pgsql-admin
Tree view 
"Gnanakumar" <gnanam@zoniac.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

pgsql-admin by date:

Previous
From: Jelena Gorelikova
Date:
Subject: pgbench-tools for Windows
Next
From: Dimitri Fontaine
Date:
Subject: Re: pgbench-tools for Windows