Re: Very slow viewing of large table.

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: Constantin Stefanov <cstef(at)mail(dot)ru>, pgadmin-support(at)postgresql(dot)org
Subject: Re: Very slow viewing of large table.
Date: 2003-10-23 10:51:04
Message-ID: 3F97B298.8040103@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Dave Page wrote:

>
>
>
>
>>-----Original Message-----
>>From: Constantin Stefanov [mailto:cstef(at)mail(dot)ru]
>>Sent: 23 October 2003 08:59
>>To: pgadmin-support(at)postgresql(dot)org
>>Subject: Re: [pgadmin-support] Very slow viewing of large table.
>>
>>
>>
>>>SELECT relname, reltuples FROM pg_class;
>>>
>>>
>>For my table there is
>>------------------------------
>>accounting# SELECT relname, reltuples FROM pg_class where
>>relname='ip_accounting';
>> relname | reltuples
>>---------------+-------------
>> ip_accounting | 7.71493e+07
>>------------------------------
>>May be there is some overflow or incorrect result parsing?
>>
>>
>
>Hmm, shouldn't be - the code appears to use longs everywhere. I can't
>really spend time on this now though - Andreas, can you take a look
>please?
>
>
It's not an overflow, instead the column is scanned as int, resulting in
reltuples=7 (which isn't too precise :-)
I changed the types of rows to wxLongLong, and estimatedRows to double now.

Regards,
Andreas

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Andreas Pflug 2003-10-23 11:02:55 Re: German umlauts in pgadmin III
Previous Message Dave Page 2003-10-23 08:18:15 Re: Very slow viewing of large table.