Re: contrib/rtree_gist into core system? - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: contrib/rtree_gist into core system?
Date
Msg-id 42C0FABE.8010307@sigaev.ru
Whole thread Raw
In response to Re: contrib/rtree_gist into core system?  (Greg Stark <gsstark@mit.edu>)
Responses Re: contrib/rtree_gist into core system?
List 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 by date:

Previous
From: Abhijit Menon-Sen
Date:
Subject: Re: #ifdef NOT_USED
Next
From: ITAGAKI Takahiro
Date:
Subject: Re: [PATCHES] O_DIRECT for WAL writes