Re: Clarification on two bits on VACUUM FULL VERBOSE output - Mailing list pgsql-performance

From Tom Lane
Subject Re: Clarification on two bits on VACUUM FULL VERBOSE output
Date
Msg-id 21555.1100287230@sss.pgh.pa.us
Whole thread Raw
In response to Clarification on two bits on VACUUM FULL VERBOSE output  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Clarification on two bits on VACUUM FULL VERBOSE output
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Clarification on two bits on VACUUM FULL VERBOSE output
Next
From: Allen Landsidel
Date:
Subject: Re: Strange (?) Index behavior?