Re: Nasty btree deletion bug

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Nasty btree deletion bug
Date: 2006-10-26 16:59:14
Message-ID: 21980.1161881954@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Heikki Linnakangas" <heikki(at)enterprisedb(dot)com> writes:
> What does the original research paper by Lanin & Shasha say about this?

Nothing very useful. The connection of our code to that paper is
actually a bit tenuous: their approach to deletion is to make the target
page's key space move left not right. That doesn't work real nicely in
my opinion (for one thing, you have to replace the left sibling's high
key, which is problematic for variable-size keys).

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Troy 2006-10-26 17:07:05 Re: Replication documentation addition
Previous Message Jeff Davis 2006-10-26 16:35:11 Re: Out of memory error causes Abort, Abort tries to