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

Поиск
Список
Период
Сортировка
От Mikheev, Vadim
Тема RE: btree split logic is fragile in the presence of lar ge index items
Дата
Msg-id 8F4C99C66D04D4118F580090272A7A23018C68@SECTORBASE1
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: JanWieck@t-online.de (Jan Wieck)
Дата:
Сообщение: Re: About TOAST and indices
Следующее
От: Larry Rosenman
Дата:
Сообщение: my stupidity