Sandeep Joshi <sjoshi(at)Zambeel(dot)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