Re: Clarification on two bits on VACUUM FULL VERBOSE output

Josh Berkus <josh@agliodbs.com> writes:
> Wanted to get clarification on two bits of output from 7.4's VACUUM FULL
> VERBOSE:

> "Total free space (including removable row versions) is 2932036 bytes."
> If the table referenced has no dead row versions, does this indicate open
> space on partially full pages?

Yes.

> "There were 33076 unused item pointers."
> Is this a count of dead index pointers, or something else?

No, it's currently-unused item pointers (a/k/a line pointers) on heap
pages.  See http://developer.postgresql.org/docs/postgres/page.html

            regards, tom lane