RE: btree split logic is fragile in the presence of lar ge index items

From: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "'Hiroshi Inoue'" <Inoue(at)tpf(dot)co(dot)jp>, pgsql-hackers(at)postgreSQL(dot)org
Subject: RE: btree split logic is fragile in the presence of lar ge index items
Date: 2000-07-20 21:30:35
Message-ID: 8F4C99C66D04D4118F580090272A7A23018C68@SECTORBASE1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-hackers by date

  From Date Subject
Next Message Larry Rosenman 2000-07-20 23:40:53 my stupidity
Previous Message Erich 2000-07-20 21:05:39 Re: Re: [HACKERS] 8Ko limitation