Re: Clarification on two bits on VACUUM FULL VERBOSE output

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

 



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 whose items had already been moved?

-- 
--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