Re: pg_class : reltuples

Sandeep Joshi <sjoshi@Zambeel.com> writes:
> I had to run "vacuum" to get corect no.s.  Why is that? I thought
> "pg_class" will be upto date.

reltuples and relpages are just updated by vacuum (and maybe create
index).  They're not intended to be accurate values, only approximate
statistics.

			regards, tom lane