Teodor Sigaev writes:
>> 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
> whil
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 mo
On Feb 12, 2009, at 2:29 PM, Tom Lane wrote:
Rusty Conover writes:
The gist__int_ops is the default operator class for integer[] arrays,
as shown at:
http://www.postgresql.org/docs/current/static/intarray.html
Ah, so you have contrib/intarray installed.
[ pokes at it... ] Seems like what
Rusty Conover writes:
> The gist__int_ops is the default operator class for integer[] arrays,
> as shown at:
> http://www.postgresql.org/docs/current/static/intarray.html
Ah, so you have contrib/intarray installed.
[ pokes at it... ] Seems like what we have here is another iteration
of this a
On Feb 12, 2009, at 1:54 PM, Tom Lane wrote:
Rusty Conover writes:
Since 100% of my queries are for retrieval, I should use GIN but it
never appears to be used unlike how GIST indexes are:
You haven't shown us either the table or the index declaration,
so it's a bit tough to comment on that
Rusty Conover writes:
> Since 100% of my queries are for retrieval, I should use GIN but it
> never appears to be used unlike how GIST indexes are:
You haven't shown us either the table or the index declaration,
so it's a bit tough to comment on that. It's worth noting though
that your GIST ex
Hi Guys,
I'm a bit confused when the proper way to use GIST versus GIN indexes
with integer arrays.
The documentation states:
http://www.postgresql.org/docs/current/static/intarray.html
The choice between GiST and GIN indexing depends on the relative
performance characteristics of GiST an
