Why does L&Y Blink Tree need lock coupling? - Mailing list pgsql-hackers

From Oliver Yang
Subject Why does L&Y Blink Tree need lock coupling?
Date
Msg-id CALJbhHPiudj4usf6JF7wuCB81fB7SbNAeyG616k+m9G0vffrYw@mail.gmail.com
Whole thread Raw
Responses Re: Why does L&Y Blink Tree need lock coupling?  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-hackers
Hi,

The README in nbtree mentions that L&Y algorithm must couple
locks when moving right during ascent for insertion.  However,
it's hard to see why that's necessary.  Since L&Y mostly
discussed concurrent insertions and searches, what can go wrong
if inserters only acquire one lock at a time?

The Lanin&ShaSha paper cited in README also agrees that B-link
structure allows inserts and searches to lock only one node at a
time although it's not apparent in L&Y itself.



Thanks,

Hong

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Checksum errors in pg_stat_database
Next
From: Tom Lane
Date:
Subject: Re: Checksum errors in pg_stat_database