Re: Row counts for large tables cause temporary hang

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...)

regards

Mark

)

Mark Kirkwood wrote:

> 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 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
>
>