Re: Vacuum problem due to temp tables

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Bhakti Ghatkar <bghatkar(at)zedo(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Vacuum problem due to temp tables
Date: 2011-03-02 15:44:33
Message-ID: AANLkTi=-WPihE+Am7HBomm269Mv+KcV5etGjjstpyphK@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Haas 2011-03-02 18:19:44 Re: Performance Test for PostgreSQL9
Previous Message Robert Haas 2011-03-02 15:39:58 Re: Query on view radically slower than query on underlying table