Re: multicolumn GIST index question

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: multicolumn GIST index question
Дата
Msg-id 87fyzfz4ih.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: multicolumn GIST index question  (Sebastian Böck <sebastianboeck@freenet.de>)
Список 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 по дате отправления:

Предыдущее
От: v.demartino2@virgilio.it
Дата:
Сообщение: Splitting tables or databases? That's the problem
Следующее
От: Karsten Hilbert
Дата:
Сообщение: Re: row numbering