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