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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings