Re: Fwd: Clarification about HOT - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Fwd: Clarification about HOT
Date
Msg-id 472F390E.8040306@enterprisedb.com
Whole thread Raw
In response to Re: Fwd: Clarification about HOT  ("Gokulakannan Somasundaram" <gokul007@gmail.com>)
Responses Re: Fwd: Clarification about HOT  ("Gokulakannan Somasundaram" <gokul007@gmail.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: minimal update
Next
From: Gregory Stark
Date:
Subject: Re: plpgsql keywords are hidden reserved words