Re: Vacuum problem due to temp tables
| От | Vidhya Bondre |
|---|---|
| Тема | Re: Vacuum problem due to temp tables |
| Дата | |
| Msg-id | AANLkTikqmNh3YvGZnGgr_=dsUgJ3Xkgs_o_q28_taWbj@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Vacuum problem due to temp tables (Robert Haas <robertmhaas@gmail.com>) |
| Ответы |
Re: Vacuum problem due to temp tables
|
| Список | pgsql-performance |
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@gmail.com> wrote:
On Mon, Feb 28, 2011 at 12:08 AM, Bhakti Ghatkar <bghatkar@zedo.com> wrote:How about just select ctid,xmin,xmax,* from pg_index?
> 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
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
В списке pgsql-performance по дате отправления: