gist problem - Mailing list pgsql-hackers

From Grzegorz Piotr Jaskiewicz
Subject gist problem
Date
Msg-id 200510262002.29987@gj-laptop
Whole thread Raw
List pgsql-hackers
Hi list

I got memleak fixed, valgrind doesn't quite find problems there, I had to dig 
it manually. 

Anyway, to the point. 
Now that I've created gist index, I want to use it on table, here it goes:

CREATE OPERATOR CLASS gist_enum2916_operators
DEFAULT FOR TYPE enum2916 USING gist
ASOPERATOR    1    >>= ,OPERATOR    2    <<= ,OPERATOR    3    >> ,OPERATOR    4    << ,OPERATOR    5    && ,OPERATOR
6    = ,
 
FUNCTION    1    enum_consistent (internal, enum2916, enum2916),FUNCTION    2    enum_union (internal,
internal),FUNCTION   3    enum_compress (internal),FUNCTION    4    enum_decompress (internal),FUNCTION    5
enum_penalty(internal, internal, internal),FUNCTION    6    enum_picksplit (internal, internal),FUNCTION    7
enum_same(enum2916, enum2916, internal);
 

than I create table and apply index to it.
At this point enable_seqscan is off.

CREATE TABLE dupa (   a integer,   b enum2916
);

--- we can now create gist index, let's do it :P
CREATE INDEX blah ON dupa USING gist (b);


I am unable to use ~ or @ operators, I thought gist would supply them for me, 
am I right ?

even through seqscan is off, on 
explain analyze select * from dupa where b <> 'something';
I get:                                           QUERY PLAN
----------------------------------------------------------------------------------------------------Seq Scan on dupa
(cost=0.00..24.50rows=580 width=36) (actual 
 
time=2.344..29.432 rows=12 loops=1)  Filter: (b <> '%.4.0.6.1.e164.digifonica.com'::enum2916)Total runtime: 29.936 ms
(3 rows)

Can someone shed a bit of light on this for me please.
This is postgres 8.1b4, basicaly cvs head.

Thanks.

-- 
GJ

Binary system, you're either 1 or 0...
dead or alive ;)


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: add_missing_from breaks existing views
Next
From: David Fetter
Date:
Subject: Re: add_missing_from breaks existing views