Re: multicolumn GIST index question

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: multicolumn GIST index question
Date: 2005-03-01 16:59:18
Message-ID: 87fyzfz4ih.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message George Essig 2005-03-01 17:17:39 Re: Backupping the table values
Previous Message v.demartino2 2005-03-01 16:52:21 Splitting tables or databases? That's the problem