Re: GiST indexing tuples

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: GiST indexing tuples
Дата
Msg-id 245.1196264092@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: GiST indexing tuples  (Matthew <matthew@flymine.org>)
Ответы Re: GiST indexing tuples  (Matthew <matthew@flymine.org>)
Список 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 по дате отправления:

Предыдущее
От: "Brendan McMahon"
Дата:
Сообщение: Optimizer regression 8.2.1 -> 8.2.3 on TSEARCH2 queries with ORDER BY and LIMIT
Следующее
От: "Dave Dutcher"
Дата:
Сообщение: Re: Query only slow on first run