> -----Original Message----- > From: Andreas Pflug [mailto:[EMAIL PROTECTED] > Sent: 23 October 2003 11:51 > To: Dave Page > Cc: Constantin Stefanov; [EMAIL PROTECTED] > Subject: Re: [pgadmin-support] Very slow viewing of large table. > > Dave Page wrote: > > > > > > > > > > >>-----Original Message----- > >>From: Constantin Stefanov [mailto:[EMAIL PROTECTED] > >>Sent: 23 October 2003 08:59 > >>To: [EMAIL PROTECTED] > >>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. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
