Josh Berkus <josh@xxxxxxxxxxxx> 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
