Re: Vacuum explained - Mailing list pgsql-admin

From Tom Lane
Subject Re: Vacuum explained
Date
Msg-id 26423.1041885959@sss.pgh.pa.us
Whole thread Raw
In response to Re: Vacuum explained  (Robert Treat <xzilla@users.sourceforge.net>)
Responses Re: Vacuum explained  (Tilo Schwarz <mail@tilo-schwarz.de>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Robert Treat
Date:
Subject: Re: Get client's IP
Next
From: Jeff Boes
Date:
Subject: ANALYZE not working?