Re: contrib/rtree_gist into core system?

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: contrib/rtree_gist into core system?
Date: 2005-06-28 07:22:38
Message-ID: 42C0FABE.8010307@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Abhijit Menon-Sen 2005-06-28 07:24:25 Re: #ifdef NOT_USED
Previous Message ITAGAKI Takahiro 2005-06-28 07:21:10 Re: [PATCHES] O_DIRECT for WAL writes