"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