Re: Very slow viewing of large table.

Dave Page wrote:

>>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?
>
> It works fine for me, so the query is probably right. When did you last
> run VACUUM ANALYZE on that table or database?
I have VACCUM ANALYZE every nignt and VACCUM FULL every week.

> The value comes from pg_class.reltuples which is updated by VACUUM
> ANALYZE:
>
> SELECT relname, reltuples FROM pg_class;
For my table there is
------------------------------
accounting# SELECT relname, reltuples FROM pg_class where
relname='ip_accounting';
relname | reltuples
---------------+-------------
ip_accounting | 7.71493e+07
------------------------------
May be there is some overflow or incorrect result parsing?

--
Constantin Stefanov