Re: Very slow viewing of large table.

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