Re: [GENERAL] pg_class : reltuples

[Tom Lane]

Sandeep Joshi <[EMAIL PROTECTED]> 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