Re: Row counts for large tables cause temporary hang

Hi Mark,

> -----Original Message-----
> From: Mark Kirkwood [mailto:markir(at)paradise(dot)net(dot)nz]
> Sent: 28 April 2004 08:00
> To: pgadmin-hackers(at)postgresql(dot)org
> Subject: [pgadmin-hackers] Row counts for large tables cause
> temporary hang
>
> Dear list,
>
> Just recently downloaded Pgadmin III 1.0.2 for win32, and am
> using it against (native) win32 Pg 7.5dev (to get a nicer
> client interface) - I am very impressed with Pgadmin, it rocks!

Thanks :-)

> The only gripe I have is the seemingly automatic count on
> tables as they are clicked on - this hangs Pgadmin for
> minutes on one of the big tables (10 million rows).

Please look under File -> Options, and on the Query tab you can set the
threshold value for the 'estimated' rows above which 'real' rows are not
counted. You need to analyse your database periodically to ensure the
estimated value stays fairly accurate (this is recommended anyway).

Regards, Dave.