Re: Vacuum problem due to temp tables

Robert,

select ctid,xmin,xmax,* from pg_index gives 2074 records.

Regards
Vidhya

On Wed, Mar 2, 2011 at 9:14 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:

> On Mon, Feb 28, 2011 at 12:08 AM, Bhakti Ghatkar <bghatkar(at)zedo(dot)com>
> 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 (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>