Re: arrays and indexes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: arrays and indexes
Дата
Msg-id 9847.1090876872@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: arrays and indexes  (Greg Stark <gsstark@mit.edu>)
Ответы Re: arrays and indexes  (Greg Stark <gsstark@mit.edu>)
Список pgsql-performance
Greg Stark <gsstark@mit.edu> writes:
> I would be curious to know how it goes. My own project uses
> denormalized sets stored as arrays as well, though in my case they're
> precalculated from the fully normalized data. I tried to use GiST
> indexes but ran into problems combining the btree-GiST code with array
> GiST code in a multicolumn index. I still don't really know why it
> failed, but after two days building the index I gave up.

Sounds like a bug to me.  Could you put together a test case?

            regards, tom lane

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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: arrays and indexes
Следующее
От: Litao Wu
Дата:
Сообщение: Re: Timestamp-based indexing