Skip site navigation (1) Skip section navigation (2)

Re: Row counts for large tables cause temporary hang

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 (view raw or flat)
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
>
>

In response to

Responses

pgadmin-hackers by date

Next:From: Andreas PflugDate: 2004-04-29 08:14:49
Subject: Re: Row counts for large tables cause temporary
Previous:From: Andreas PflugDate: 2004-04-28 20:56:57
Subject: Re: Creation of XPM files for wxWidgets

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group