Re: GiST indexing tuples

Поиск
Список
Период
Сортировка
От Matthew T. O'Connor
Тема Re: GiST indexing tuples
Дата
Msg-id 474F1FAE.3050700@zeut.net
обсуждение исходный текст
Ответ на Re: GiST indexing tuples  (Matthew <matthew@flymine.org>)
Ответы Re: GiST indexing tuples  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
Re: GiST indexing tuples  (Matthew <matthew@flymine.org>)
Список pgsql-performance
Matthew wrote:
> For instance, the normal B-tree index on (a, b) is able to answer queries
> like "a = 5 AND b > 1" or "a > 5". An R-tree would be able to index these,
> plus queries like "a > 5 AND b < 1".

Sorry in advance if this is a stupid question, but how is this better
than two index, one on "a" and one on "b"?  I supposed there could be a
space savings but beyond that?


В списке pgsql-performance по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Configuring a Large RAM PostgreSQL Server
Следующее
От: "Steinar H. Gunderson"
Дата:
Сообщение: Re: GiST indexing tuples