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

Re: Row counts for large tables cause temporary

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Row counts for large tables cause temporary
Date: 2004-04-29 08:14:49
Message-ID: 4090B979.2050401@pse-consulting.de (view raw or flat)
Thread:
Lists: pgadmin-hackers
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.

Regards,
Andreas


In response to

Responses

pgadmin-hackers by date

Next:From: Mark KirkwoodDate: 2004-04-29 09:10:25
Subject: Re: Row counts for large tables cause temporary
Previous:From: Mark KirkwoodDate: 2004-04-29 06:24:06
Subject: Re: Row counts for large tables cause temporary hang

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