Re: Race condition within _bt_findinsertloc()? (new page split code) - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Race condition within _bt_findinsertloc()? (new page split code)
Date
Msg-id 5384F97E.7070101@vmware.com
Whole thread Raw
In response to Re: Race condition within _bt_findinsertloc()? (new page split code)  (Peter Geoghegan <pg@heroku.com>)
List pgsql-hackers
On 05/27/2014 11:30 PM, Peter Geoghegan wrote:
> On Tue, May 27, 2014 at 12:19 PM, Heikki Linnakangas
> <hlinnakangas@vmware.com> wrote:
>> Ah, sorry, I got that wrong. The downlinks store the *low* key of the child
>> page, not the high key as I depicted. Let me try again:
>
> Would you mind humoring me, and including a corrected final
> post-downlink-insert diagram, when the split is fully complete? You
> omitted that.

Sure:

Parent page
+-------------+
| 7 -> A      |
| 8 -> B      |
+-------------+

Leaf A              Leaf B
+--------------+     +-------------+
| HI-key: 8    |     | HI-key: 9   |
|              |     |             |
|              | <-> |             |
|              |     |             |
|  7   7*  8   |     |    9        |
+--------------+     +-------------+

- Heikki



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Race condition within _bt_findinsertloc()? (new page split code)
Next
From: Tom Lane
Date:
Subject: Re: json casts