From: | Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> |
---|---|
To: | Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> |
Cc: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk>, pgadmin-hackers(at)postgresql(dot)org |
Subject: | Re: Row counts for large tables cause temporary hang |
Date: | 2004-04-29 06:24:06 |
Message-ID: | 40909F86.9040504@paradise.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2004-04-29 08:14:49 | Re: Row counts for large tables cause temporary |
Previous Message | Andreas Pflug | 2004-04-28 20:56:57 | Re: Creation of XPM files for wxWidgets |