Re: Very slow viewing of large table.

Dave Page wrote:

>>-----Original Message-----
>>From: Constantin Stefanov [mailto:cstef(at)mail(dot)ru]
>>Sent: 22 October 2003 14:53
>>To: pgadmin-support(at)postgresql(dot)org
>>Subject: [pgadmin-support] Very slow viewing of large table.
>>
>>When in PgAdmin3 I click on a large table, it waits before
>>opening it.
>>As far as I could understand, it issues a row count on a
>>table. Is there way to stop this behaviour?
>>I found a letter about the same problem of February 2002, and
>>Dave Page wrote he was intending to do something about.
>>Am I searching in the wrong place or there is no capability
>>for cancelling count queries?
>
> Under File -> Options -> Query there is an option to control this
> behaviour, though unless you have a slow server, it should have a
> sensible value following install. From the helpfile:
>
> "Count rows if estimated less than" - In the object browser, if the
> estimated number of rows in a table (as read from the table statistics)
> is below this limit, a SELECT count(*) will be performed to find the
> exact value.
Thanks, I set that value to 0, and now I have the desired behaviour.
But, for that table the values are:
Rows(estimated) - 7
Rows(counted) - 77204608
I think the difference is too large. From the debug output I could not
understand the query which pg_admin issues to have the value for
estimated number of rows. Could you show me that query so I could give
it directly from psql to see whether there is an error in my database
stats or there is a bug in pg_admin when interpreting query result?

--
Constantin Stefanov