Re: GiST indexing tuples

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: Matthew <matthew(at)flymine(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: GiST indexing tuples
Date: 2007-11-29 20:23:10
Message-ID: 474F1FAE.3050700@zeut.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Steinar H. Gunderson 2007-11-29 20:30:24 Re: GiST indexing tuples
Previous Message Alvaro Herrera 2007-11-29 19:29:19 Re: Configuring a Large RAM PostgreSQL Server