Re: GiST indexing tuples - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: GiST indexing tuples
Date
Msg-id 20071129203024.GB5705@uio.no
Whole thread Raw
In response to Re: GiST indexing tuples  ("Matthew T. O'Connor" <matthew@zeut.net>)
List pgsql-performance
On Thu, Nov 29, 2007 at 03:23:10PM -0500, Matthew T. O'Connor wrote:
> 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?

You could index on both columns simultaneously without a bitmap index scan.

/* Steinar */
--
Homepage: http://www.sesse.net/

pgsql-performance by date:

Previous
From: "Matthew T. O'Connor"
Date:
Subject: Re: GiST indexing tuples
Next
From: "Campbell, Lance"
Date:
Subject: clear pg_stats