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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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-12 14:21:12
Message-ID: 13080.1318429272@sss.pgh.pa.us
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 could do something like

select relname from pg_class where relam = (select oid from pg_am where amname = 'gist');

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2011-10-12 14:37:30 Re: How to find and/or REINDEX only GiST indexes in the database?
Previous Message Achilleas Mantzios 2011-10-12 14:07:05 Re: How to find and/or REINDEX only GiST indexes in the database?