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

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

> > "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

So this would be a count of pointers whose items had already been moved?

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

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