Re: Very slow viewing of large table.

> -----Original Message-----
> From: Andreas Pflug [mailto:pgadmin@pse-consulting.de]
> Sent: 23 October 2003 11:51
> To: Dave Page
> Cc: Constantin Stefanov; pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] Very slow viewing of large table.
>
> Dave Page wrote:
>
> >
> >
> >
> >
> >>-----Original Message-----
> >>From: Constantin Stefanov [mailto:cstef@mail.ru]
> >>Sent: 23 October 2003 08:59
> >>To: pgadmin-support@postgresql.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.

Of course (kicking myself now...)

Regards, Dave.