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