Re: multicolumn GIST index question

From: Sebastian Böck <sebastianboeck(at)freenet(dot)de>
To: rm_postgis(at)cheapcomplexdevices(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: multicolumn GIST index question
Date: 2005-03-01 07:24:54
Message-ID: 422418C6.4000906@freenet.de
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?

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tommy Svensson 2005-03-01 07:28:00 Re: Referencing created tables fails with message that
Previous Message Tom Lane 2005-03-01 04:25:16 Re: vacuum_cost_delay & VACUUM holding locks on GIST indexes