Subject Re: [Firebird-Architect] Bi-directional indexes
Author Dmitry Yemanov
"Geoff Worboys" <geoff@...> wrote:
> I am not familiar with what you mean by "handoff" - which is
> probably why I do not understand why the backward reader cannot
> try to get a lock on the next page before it releases the page
> that it holds.

A handoff is an atomic move from one page to another. The currently fetched
page is released only after the next page is fetched successfully. Two
handoffs 1->2 and 2->1 deadlock, because there can be only one lock holder
of the given page.