Re: [PERFORM] GIST versus GIN indexes for intarrays

Поиск
Список
Период
Сортировка
От Kenneth Marshall
Тема Re: [PERFORM] GIST versus GIN indexes for intarrays
Дата
Msg-id 20090213140458.GA4134@it.is.rice.edu
обсуждение исходный текст
Ответ на Re: [PERFORM] GIST versus GIN indexes for intarrays  (Teodor Sigaev <teodor@sigaev.ru>)
Список pgsql-hackers
On Fri, Feb 13, 2009 at 04:12:53PM +0300, Teodor Sigaev wrote:
>> The short-term workaround for Rusty is probably to create his GIN
>> index using the intarray-provided gin__int_ops opclass.  But it
> Right
>> seems to me that we ought to get rid of intarray's @> and <@ operators
>> and have the module depend on the core anyarray operators, just as we
>> have already done for = and <>.  Comments?
> Agree, will do. Although built-in anyarray operators have ~N^2 behaviour
> while intarray's version - only N*log(N)
Is there a way to have the buily-in anyarray opeators be N*log(N)?

Ken

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: GIN fast insert
Следующее
От: Joshua Brindle
Дата:
Сообщение: Re: Updates of SE-PostgreSQL 8.4devel patches (r1530)