Re: Vacuum problem due to temp tables

[Vidhya Bondre <meetvbondre@xxxxxxxxx>]

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@xxxxxxxxx> wrote:

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