Robert, select ctid,xmin,xmax,* from pg_index gives 2074 records.
Regards Vidhya On Wed, Mar 2, 2011 at 9:14 PM, Robert Haas <[email protected]> wrote: > On Mon, Feb 28, 2011 at 12:08 AM, Bhakti Ghatkar <[email protected]> > wrote: > > Tom, > > The query which you gave returns me 0 rows. > > select ctid,xmin,xmax,* from pg_index where indexrelid in > > (select indexrelid from pg_index group by 1 having count(*)>1); > > Regards, > > Bhakti > > How about just select ctid,xmin,xmax,* from pg_index? > > -- > Robert Haas > EnterpriseDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > > -- > Sent via pgsql-performance mailing list ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance >
