Clarification on two bits on VACUUM FULL VERBOSE output

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Clarification on two bits on VACUUM FULL VERBOSE output
Date: 2004-11-12 18:42:02
Message-ID: 200411121042.02759.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Folks,

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?

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

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2004-11-12 19:20:30 Re: Clarification on two bits on VACUUM FULL VERBOSE output
Previous Message Joshua D. Drake 2004-11-11 21:48:27 Re: Strange (?) Index behavior?