Re: contrib/rtree_gist into core system?

Поиск
Список
Период
Сортировка
От Teodor Sigaev
Тема Re: contrib/rtree_gist into core system?
Дата
Msg-id 42C0FABE.8010307@sigaev.ru
обсуждение исходный текст
Ответ на Re: contrib/rtree_gist into core system?  (Greg Stark <gsstark@mit.edu>)
Ответы Re: contrib/rtree_gist into core system?  (Greg Stark <gsstark@mit.edu>)
Список pgsql-hackers
> I think we still have a serious problem with multicolumn indexes. As they
> stand they're basically only indexes on the first column. The later columns
> are not used to determine page splits.

1. In your meaning, btree has bad split algorithm too. Look at _bt_compare, if 
first keys on page are unique the the later keys will not be compared ;)

2. About rtree interface: it's possible to write GiST-RTree layer compatibility 
interface. User's interface will just copied from RTree, and layer will 
translate it to GiST interface.


-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
  WWW: http://www.sigaev.ru/
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Abhijit Menon-Sen
Дата:
Сообщение: Re: #ifdef NOT_USED
Следующее
От: ITAGAKI Takahiro
Дата:
Сообщение: Re: [PATCHES] O_DIRECT for WAL writes