"Heikki Linnakangas" <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>>> Another real problem with doing pruning only in UPDATE path is that
>>> we may end up with long HOT chains if the page does not receive a
>>> UPDATE, after many consecutive HOT updates.
>> 
>> How is that, if the same number of prune attempts would occur?

> It wouldn't. To avoid the long HOT chains, we want to prune more often
> than what's needed to just make room for updates.

I don't follow.  HOT chains can only get longer by updates.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to