Re: Vacuum explained

Robert Treat <xzilla@users.sourceforge.net> writes:
> Tup = # of "rows" in your table

Right.  This is the number of rows remaining after the vacuum, to be
precise.

> Keep = # of tuples that the db did not feel it could safely mark/remove
> (probably envolved in some type of transaction)

More specifically, these are tuples that are committed dead, but cannot
yet be removed because they might still be visible under the MVCC rules
to one or more open transactions.  This number is included in "Tup".

> Unused = # of tuples awaiting being reused

These are not actually tuples, but tuple slots (page item pointers)
that are open for re-use.

            regards, tom lane