Re: Fwd: Clarification about HOT

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Fwd: Clarification about HOT
Дата
Msg-id 472F390E.8040306@enterprisedb.com
обсуждение исходный текст
Ответ на Re: Fwd: Clarification about HOT  ("Gokulakannan Somasundaram" <gokul007@gmail.com>)
Ответы Re: Fwd: Clarification about HOT  ("Gokulakannan Somasundaram" <gokul007@gmail.com>)
Список pgsql-hackers
Gokulakannan Somasundaram wrote:
> Thanks Heikki. To clarify, there won't be any redirect-line pointers in this
> implementation. That space is saved. We will have the index tuple point to
> the latest live tuple in the update chain.  So no need for redirect-line
> pointers.

The redirected line pointers are there for a reason. The reason is to be 
able to retail vacuum (= prune) a page without having to do a regular 
vacuum, scanning all indexes.

If you lose that ability, the idea is dead in the water.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: minimal update
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: plpgsql keywords are hidden reserved words