Re: Dead code in _bt_split? - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Dead code in _bt_split?
Date
Msg-id 45C8A773.5070306@enterprisedb.com
Whole thread Raw
In response to Re: Dead code in _bt_split?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Heikki Linnakangas <heikki@enterprisedb.com> writes:
>> Bruce Momjian wrote:
>>> OK, would you please send a patch to remove the unused code.  Thanks.
> 
>> Ok, here you are.
> 
> Applied with an added comment and Assert.
> 
> While testing it I realized that there seems to be a nearby bug in
> _bt_findsplitloc: it fails to consider the possibility of moving all the
> extant items to the left side.  It will always return a firstright <=
> maxoff.  ISTM this would mean that it could choose a bad split if the
> incoming item goes at the end and both it and the last extant item are
> large: in this case they should be split apart, but they won't be.
> 
> Heikki, do you feel like looking at that, or shall I?

I'll take a look at it.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Pl/pgsql functions causing crashes in 8.2.2
Next
From: "Jonathan Gray"
Date:
Subject: Pl/pgsql functions causing crashes in 8.2.2