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

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-admin(at)postgresql(dot)org>,<gnanam(at)zoniac(dot)com>
Subject: Re: How to find and/or REINDEX only GiST indexes in the database?
Date: 2011-10-12 14:37:30
Message-ID: 4E955FDA0200002500041E9F@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Gnanakumar" <gnanam(at)zoniac(dot)com> wrote:

> how do I find out or REINDEX *only* GiST indexes in the
> database? Is there a single syntax/command that does this?

I would probably capture the output from:

SELECT indexdef || ';'
FROM pg_indexes
WHERE indexdef ~ ' USING gist ';

-Kevin

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message gabriel12345 2011-10-12 20:35:00 Re: Contents of WAL files
Previous Message Tom Lane 2011-10-12 14:21:12 Re: How to find and/or REINDEX only GiST indexes in the database?