Re: n_live_tup count increase after vacuum - Mailing list pgsql-general

From Tom Lane
Subject Re: n_live_tup count increase after vacuum
Date
Msg-id 22870.1568902473@sss.pgh.pa.us
Whole thread Raw
In response to n_live_tup count increase after vacuum  (Jason Ralph <jralph@affinitysolutions.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PGPASSWORD in crypted form, for example BlowFish or SHA-256
Next
From: Stephen Frost
Date:
Subject: Re: pgbackrest - question about restoring cluster to a new clusteron same server