Re: [PERFORM] GIST versus GIN indexes for intarrays

Поиск
Список
Период
Сортировка
От Teodor Sigaev
Тема Re: [PERFORM] GIST versus GIN indexes for intarrays
Дата
Msg-id 499571D5.6000906@sigaev.ru
обсуждение исходный текст
Ответ на Re: [PERFORM] GIST versus GIN indexes for intarrays  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [PERFORM] GIST versus GIN indexes for intarrays
Re: [PERFORM] GIST versus GIN indexes for intarrays
Список pgsql-hackers
> 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)
-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
  WWW: http://www.sigaev.ru/
 


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

Предыдущее
От: Zdenek Kotala
Дата:
Сообщение: Re: pg_upgrade project status
Следующее
От: Robert Haas
Дата:
Сообщение: Re: GIN fast insert