Clarification on two bits on VACUUM FULL VERBOSE output

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Folks,

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?

"There were 33076 unused item pointers."
Is this a count of dead index pointers, or something else?

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux