Re: wrong indexes sizes on index page

From: Thom Brown <thom(at)linux(dot)com>
To: Timon <timosha(at)gmail(dot)com>
Cc: Guillaume Lelarge <guillaume(at)lelarge(dot)info>, pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: wrong indexes sizes on index page
Date: 2010-10-12 12:37:53
Message-ID: AANLkTinFMUqbqaK=ofVkpQ_g7NQ74jR4ezda26oh7Fuf@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

On 12 October 2010 11:01, Timon <timosha(at)gmail(dot)com> wrote:
> 2010/10/12 Guillaume Lelarge <guillaume(at)lelarge(dot)info>:
>> Le 12/10/2010 11:47, Thom Brown a écrit :
>>> On 12 October 2010 10:29, Timon <timosha(at)gmail(dot)com> wrote:
>>>> see attachment.
>>>> Last column on table shows index size, but 227MB - is table size.
>>>>
>>>> postgresql 8.4.4
>>>>
>>>> pgadmin 1.13 last dev build from git
>>>>
>>>
>>> I can confirm this using pgAdmin ... weird special version Dave gave
>>> me last week ... against PostgreSQL 8.3.1, and PostgreSQL 9.0.0.
>>>
>>
>> I don't think we changed anything in this area. So you should have the
>> same issue with 1.12.
> yes, I have this issue with 1.12.

Looks like it's getting the OID of the table the index is associated
with rather than just using the indexrelid column from
pg_stat_all_indexes.

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2010-10-12 14:57:03 Re: [pgadmin-support] pgAdmin v1.12.0 Released
Previous Message Timon 2010-10-12 10:01:45 Re: wrong indexes sizes on index page