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 = 10000000
however reltuples in pg_class shows 1e07, so it looks like pgadmin is
not representing the "real" datatype correctly (maybe a 7,5 thing - tho
the datatype of pg_class is the same in 7.4). Any ideas?
I will try the same test on my home system (Freebsd 4.9) with Pg 7.4
(assuming I can get pgadmin to build on 4.9...)
Mark Kirkwood wrote:
> Oops...missed that one (and it's in an obvious place too....).
> Thanks, I will set it!
> 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 database periodically to ensure the
>> estimated value stays fairly accurate (this is recommended anyway).
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
In response to
pgadmin-hackers by date
|Next:||From: Andreas Pflug||Date: 2004-04-29 08:14:49|
|Subject: Re: Row counts for large tables cause temporary|
|Previous:||From: Andreas Pflug||Date: 2004-04-28 20:56:57|
|Subject: Re: Creation of XPM files for wxWidgets|