Re: n_live_tup count increase after vacuum

Jason Ralph <jralph@affinitysolutions.com> writes:
> I recently upgraded a neglected DB in our fleet that contains a huge table (1.4B) rows.  I ran a vacuum against the
hugetable, as expected it took a long time, but it did finish. 
> I think I understand most of what the output is saying... one confusing thing....
> The number of "live " tuples went up..(?)

If you're looking at the pg_stat counter, that's only an approximation.
It's probably a better approximation now than it was before.

            regards, tom lane