Thread: Multicolumn Indexing using R-Tree

Multicolumn Indexing using R-Tree

From

lima_caetano@yahoo.com.br (Marcio Caetano)

Date:

03 February 2004, 18:08:59

Hello !

I'm using PostgreSQL 7.3.2 and I need to create a R-Tree index that
uses more than one column in a table.

When I run the instruction it appears this message bellow:

DefineIndex: access method "rtree" does not support multi-column
indexes


How can I solve this problem ? 
Is it a limitation of PostgreSQL or the R-Tree concept  ?

Thank you in advance.

Márcio Caetano.

Re: Multicolumn Indexing using R-Tree

From

Teodor Sigaev

Date:

03 February 2004, 18:51:38

Try contrib/rtree_gist

Marcio Caetano wrote:
> Hello !
> 
> I'm using PostgreSQL 7.3.2 and I need to create a R-Tree index that
> uses more than one column in a table.
> 
> When I run the instruction it appears this message bellow:
> 
> DefineIndex: access method "rtree" does not support multi-column
> indexes
> 
> 
> How can I solve this problem ? 
> Is it a limitation of PostgreSQL or the R-Tree concept  ?
> 
> Thank you in advance.
> 
> Márcio Caetano.
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

-- 
Teodor Sigaev                                  E-mail: teodor@sigaev.ru

Re: Multicolumn Indexing using R-Tree

From

Paul Ramsey

Date:

03 February 2004, 19:00:18

Try using GiST rtree (examples in contrib), GiST supports multi-key
indexes.

On Tuesday, February 3, 2004, at 06:56 AM, Marcio Caetano wrote:

> I'm using PostgreSQL 7.3.2 and I need to create a R-Tree index that
> uses more than one column in a table.
>
> When I run the instruction it appears this message bellow:
>
> DefineIndex: access method "rtree" does not support multi-column
> indexes
>
> How can I solve this problem ?
> Is it a limitation of PostgreSQL or the R-Tree concept  ?
>
> Thank you in advance.
>
> Márcio Caetano