Re: [pgadmin-hackers] Row counts for large tables cause temporary hang

2004-04-28 Thread Mark Kirkwood
Hmm ... it is set already (count rows if estimated < 2000) Checking in the properties window for that table concerned shows : rows estimated = 1 rows counted = 1000 however reltuples in pg_class shows 1e07, so it looks like pgadmin is not representing the "real" datatype correctly (maybe a 7,5

Re: [pgadmin-hackers] Row counts for large tables cause temporary hang

2004-04-28 Thread Mark Kirkwood
Oops...missed that one (and it's in an obvious place too). Thanks, I will set it! regards Mark Dave Page wrote: 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 data

Re: [pgadmin-hackers] Row counts for large tables cause temporary hang

2004-04-28 Thread Dave Page
Hi Mark, > -Original Message- > From: Mark Kirkwood [mailto:[EMAIL PROTECTED] > Sent: 28 April 2004 08:00 > To: [EMAIL PROTECTED] > Subject: [pgadmin-hackers] Row counts for large tables cause > temporary hang > > Dear list, > > Just recently download

[pgadmin-hackers] Row counts for large tables cause temporary hang

2004-04-28 Thread Mark Kirkwood
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! The only gripe I have is the seemingly automatic count on tables as they are clicked on - this hangs