Re: [PERFORM] Clarification on two bits on VACUUM FULL VERBOSE output

Josh Berkus <[EMAIL PROTECTED]> writes: >>> "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 > S

Re: [PERFORM] Clarification on two bits on VACUUM FULL VERBOSE output

Tom, > > "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 So this would be a count of pointers who

Re: [PERFORM] Clarification on two bits on VACUUM FULL VERBOSE output

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