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

Re: Row counts for large tables cause temporary

From: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
To: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Row counts for large tables cause temporary
Date: 2004-04-29 09:10:25
Message-ID: 4090C681.1080302@paradise.net.nz (view raw or flat)
Thread:
Lists: pgadmin-hackers

Andreas Pflug wrote:

> Mark Kirkwood wrote:
>
>> 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? 
>
>
>
> Known problem, use 1.1.0.
>
>
Thanks.

In response to

pgadmin-hackers by date

Next:From: Chris GamacheDate: 2004-04-29 19:46:42
Subject: Suggestion: Implicit permissions on implicitly generated objects
Previous:From: Andreas PflugDate: 2004-04-29 08:14:49
Subject: Re: Row counts for large tables cause temporary

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