Re: Clarification about HOT - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Clarification about HOT
Date
Msg-id 472B4E92.1060807@enterprisedb.com
Whole thread Raw
In response to Re: Clarification about HOT  ("Gokulakannan Somasundaram" <gokul007@gmail.com>)
Responses Re: Clarification about HOT
List pgsql-hackers
Gokulakannan Somasundaram wrote:
> I understand that if you have to Vacuum a tuple, it has to satisfy the
> necessary snapshot requirements. i will never be able to reduce the chain to
> just one, because the there is always a indirection at the top of HOT. I
> understood this.
> 
> My question was is it the only reason for the decision to stop HOT across
> pages.

Another reason is that it avoids the whole problem of updating multiple 
pages atomically, without deadlocks.

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


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: minimal update
Next
From: "Gokulakannan Somasundaram"
Date:
Subject: Re: Proposal: Select ... AS OF Savepoint