Re: Dead Space Map for vacuum

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Dead Space Map for vacuum
Дата
Msg-id 2589.1167407395@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Dead Space Map for vacuum  ("Simon Riggs" <simon@2ndquadrant.com>)
Ответы Re: Dead Space Map for vacuum  ("Simon Riggs" <simon@2ndquadrant.com>)
Список pgsql-hackers
"Simon Riggs" <simon@2ndquadrant.com> writes:
> I would suggest that we tracked whether a block has had 0, 1 or 1+
> updates/deletes against it. When a block has 1+ it can then be
> worthwhile to VACUUM it and to place it onto the FSM. Two dead tuples is
> really the minimum space worth reclaiming on any block.

How do you arrive at that conclusion?

Counterexample: table in which all tuples exceed half a page.
        regards, tom lane


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

Предыдущее
От: Brian Hurt
Дата:
Сообщение: Re: [PATCHES] [BUGS] BUG #2846: inconsistent and
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: TODO: GNU TLS