Re: reading vacuum verbosity

"Ed L." <pgsql@bluepolka.net> writes:
> One oddity:  Even immediately after a vacuum or analyze, I notice that
> pg_class.reltuples is way off for this table, reporting 919373 rows
> when there are only ~284K.  pg_class.relpages looks precisely correct.
> This is PostgreSQL 7.3.4 on hppa2.0w-hp-hpux11.00, compiled by cc -Ae.

I'd expect reltuples to be correct after a VACUUM (or VACUUM ANALYZE).
But a plain ANALYZE sets it on the basis of a statistical estimate that
can be off quite a bit.  (Manfred's been looking at developing a better
estimate, which I hope will make it into 7.5.)

            regards, tom lane