Re: Clarification on two bits on VACUUM FULL VERBOSE output

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Clarification on two bits on VACUUM FULL VERBOSE output
Дата
Msg-id 200411121311.33769.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: Clarification on two bits on VACUUM FULL VERBOSE output  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Clarification on two bits on VACUUM FULL VERBOSE output  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Allen Landsidel
Дата:
Сообщение: Re: Strange (?) Index behavior?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Clarification on two bits on VACUUM FULL VERBOSE output