Postgres Pro
Downloads
Home   >   mailing lists

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

From Sebastian Böck
Subject Re: multicolumn GIST index question
Date
Msg-id 422418C6.4000906@freenet.de
Whole thread Raw
In response to multicolumn GIST index question  (Ron Mayer <rm_postgis@cheapcomplexdevices.com>)
Responses Re: multicolumn GIST index question  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
Tree view 
Ron Mayer wrote:
>
> Did anyone get multi-column GIST indexes working using both
> the gist_btree and postgis modules?

Not quite stable yet.

> It seems to work fine for me on small test cases (shown
> at the bottom), but seems to crash my database for large
> ones.   Any advice is welcome - including pointers to better
> lists to ask questions like this.

For me it seems to work only if the geom-column
is the first column in a multicolumn-index.

Haven't investigated further so far...

HTH

Sebastian

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: vacuum_cost_delay & VACUUM holding locks on GIST indexes
Next
From: Tommy Svensson
Date:
Subject: Re: Referencing created tables fails with message that