Re: Very slow viewing of large table.

> -----Original Message-----
> From: Constantin Stefanov [mailto:cstef(at)mail(dot)ru]
> Sent: 23 October 2003 07:30
> To: pgadmin-support(at)postgresql(dot)org
> Subject: Re: [pgadmin-support] Very slow viewing of large table.
>
> 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?

The value comes from pg_class.reltuples which is updated by VACUUM
ANALYZE:

SELECT relname, reltuples FROM pg_class;

Regards, Dave.