Re: [PERFORM] GIST versus GIN indexes for intarrays - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: [PERFORM] GIST versus GIN indexes for intarrays
Date
Msg-id 499571D5.6000906@sigaev.ru
Whole thread Raw
In response to Re: [PERFORM] GIST versus GIN indexes for intarrays  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [PERFORM] GIST versus GIN indexes for intarrays  (Kenneth Marshall <ktm@rice.edu>)
Re: [PERFORM] GIST versus GIN indexes for intarrays  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: pg_upgrade project status
Next
From: Robert Haas
Date:
Subject: Re: GIN fast insert