Re: GiST indexing tuples - Mailing list pgsql-performance

From Matthew T. O'Connor
Subject Re: GiST indexing tuples
Date
Msg-id 474F1FAE.3050700@zeut.net
Whole thread Raw
In response to Re: GiST indexing tuples  (Matthew <matthew@flymine.org>)
Responses Re: GiST indexing tuples  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
Re: GiST indexing tuples  (Matthew <matthew@flymine.org>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Configuring a Large RAM PostgreSQL Server
Next
From: "Steinar H. Gunderson"
Date:
Subject: Re: GiST indexing tuples