Re: multicolumn GIST index question

Поиск
Список
Период
Сортировка
От Sebastian Böck
Тема Re: multicolumn GIST index question
Дата
Msg-id 422418C6.4000906@freenet.de
обсуждение исходный текст
Ответ на multicolumn GIST index question  (Ron Mayer <rm_postgis@cheapcomplexdevices.com>)
Ответы Re: multicolumn GIST index question  (Greg Stark <gsstark@mit.edu>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: vacuum_cost_delay & VACUUM holding locks on GIST indexes
Следующее
От: Tommy Svensson
Дата:
Сообщение: Re: Referencing created tables fails with message that