Re: multicolumn GIST index question - Mailing list pgsql-general

From Greg Stark
Subject Re: multicolumn GIST index question
Date
Msg-id 87fyzfz4ih.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: multicolumn GIST index question  (Sebastian Böck <sebastianboeck@freenet.de>)
List pgsql-general
> Ron Mayer wrote:
> > Did anyone get multi-column GIST indexes working using both
> > the gist_btree and postgis modules?

Multi-column gist indexes are basically useless at this point. The index pages
are split based entirely on the first column, so the index becomes basically
an index on the first column.

There was some discussion on changing this but there wasn't consensus on which
direction to head with it. It may come up again for 8.1 if someone wants to
look at it.

--
greg

pgsql-general by date:

Previous
From: v.demartino2@virgilio.it
Date:
Subject: Splitting tables or databases? That's the problem
Next
From: Karsten Hilbert
Date:
Subject: Re: row numbering