RE: btree split logic is fragile in the presence of lar ge index items - Mailing list pgsql-hackers

From Mikheev, Vadim
Subject RE: btree split logic is fragile in the presence of lar ge index items
Date
Msg-id 8F4C99C66D04D4118F580090272A7A23018C68@SECTORBASE1
Whole thread Raw
List pgsql-hackers
> I believe that the equal-key performance problem largely 
> comes from the bogus way we've been handling duplicates, in particular

It comes from the way we look for page for new tuple - _bt_insertonpg tries
to avoid duplicate page splitting, i.e. if there is no space for new tuple
on the leftmost page, it reads next right page... etc...

> the fact that findsplitloc has to worry about choosing a "legal split
> point" for a series of duplicates.  Once we get rid of that, I think
> findsplitloc can use a binary search.

Vadim


pgsql-hackers by date:

Previous
From: JanWieck@t-online.de (Jan Wieck)
Date:
Subject: Re: About TOAST and indices
Next
From: Larry Rosenman
Date:
Subject: my stupidity