Re: Clarification about HOT

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