Skip site navigation (1) Skip section navigation (2)

Re: Very slow viewing of large table.

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Andreas Pflug" <pgadmin(at)pse-consulting(dot)de>
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 11:36:21
Message-ID: 03AF4E498C591348A42FC93DEA9661B84C5C3D@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support
 

> -----Original Message-----
> From: Andreas Pflug [mailto:pgadmin(at)pse-consulting(dot)de] 
> Sent: 23 October 2003 11:51
> To: Dave Page
> Cc: Constantin Stefanov; pgadmin-support(at)postgresql(dot)org
> Subject: Re: [pgadmin-support] 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.

Of course (kicking myself now...)

Regards, Dave.

pgadmin-support by date

Next:From: Andreas PflugDate: 2003-10-23 11:36:52
Subject: Re: Execute TO in PgadminIII
Previous:From: Andreas PflugDate: 2003-10-23 11:08:39
Subject: Re: [pgadmin-support] EXPORT from Query Tool

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group