Re: Clarification on two bits on VACUUM FULL VERBOSE output

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: josh(at)agliodbs(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Clarification on two bits on VACUUM FULL VERBOSE output
Date: 2004-11-12 19:20:30
Message-ID: 21555.1100287230@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Josh Berkus <josh(at)agliodbs(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Allen Landsidel 2004-11-12 20:12:35 Re: Strange (?) Index behavior?
Previous Message Josh Berkus 2004-11-12 18:42:02 Clarification on two bits on VACUUM FULL VERBOSE output