Re: HOT line pointer bloat and PageRepairFragmentation

Поиск
Список
Период
Сортировка
От Pavan Deolasee
Тема Re: HOT line pointer bloat and PageRepairFragmentation
Дата
Msg-id 2e78013d0709130956t37e961fbs329567eefe072d2a@mail.gmail.com
обсуждение исходный текст
Ответ на Re: HOT line pointer bloat and PageRepairFragmentation  ("Zeugswetter Andreas ADI SD" <Andreas.Zeugswetter@s-itsolutions.at>)
Список pgsql-hackers


On 9/13/07, Zeugswetter Andreas ADI SD <Andreas.Zeugswetter@s-itsolutions.at> wrote:

> The COLD updated (old) tuple would be pruned to dead line pointer
> once the tuple becomes DEAD. Normally that would let us reuse the
> tuple storage for other purposes. We do the same for DELETEd tuples.

Oh, I thought only pruned tuples from HOT chains can produce a
"redirect dead" line pointer.

This looks like a problem, since we might end up with a page filled with
LP_DEAD slots, that all have no visibility info and can thus not be
cleaned
by vacuum.


It has nothing to do with visibility info. We already know the tuple is DEAD
and thats why its line pointer is LP_DEAD.

Thanks,
Pavan

--
Pavan Deolasee
EnterpriseDB     http://www.enterprisedb.com

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

Предыдущее
От: "Zeugswetter Andreas ADI SD"
Дата:
Сообщение: Re: HOT line pointer bloat and PageRepairFragmentation
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: autovacuum launcher eating too much CPU