Re: GiST indexing tuples - Mailing list pgsql-performance

From Tom Lane
Subject Re: GiST indexing tuples
Date
Msg-id 245.1196264092@sss.pgh.pa.us
Whole thread Raw
In response to Re: GiST indexing tuples  (Matthew <matthew@flymine.org>)
Responses Re: GiST indexing tuples
List pgsql-performance
Matthew <matthew@flymine.org> writes:
>> This sounds like something an R-tree can do.

> I *know* that. However, Postgres (as far as I can see) doesn't provide a
> simple R-tree index that will index two integers. This means I have to
> write one myself. I'm asking whether it is possible to get two values into
> a GiST index, which would allow me to implement this.

Have you looked at contrib/seg/ ?

            regards, tom lane

pgsql-performance by date:

Previous
From: "Brendan McMahon"
Date:
Subject: Optimizer regression 8.2.1 -> 8.2.3 on TSEARCH2 queries with ORDER BY and LIMIT
Next
From: "Dave Dutcher"
Date:
Subject: Re: Query only slow on first run