Josh Berkus <[EMAIL PROTECTED]> writes: > Wanted to get clarification on two bits of output from 7.4's VACUUM FULL > VERBOSE:
Advertising
> "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
