Josh Berkus <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to