Jason Ralph <jra...@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 huge table, 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