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 по дате отправления: