Re: creating index on changed field type

Użytkownik Tom Lane napisał:

> David Smith <gegez-pgh@instytut.com.pl> writes:
> 
>>Should I forget about btrees and move to GIST,
> 
> 
> Yes.  There's no provision in the btree code for an index storage type
> different from the column datatype.
> 
>             regards, tom lane
> 
> 
Thank You for reply.
Let us suppose, the we retain type of field (column). But instead of 
storing original value(key), we will store tokens(Instead 'this is my 
first text', we would keep 5 tokens (5 different BTItems) respectively: 
'this', 'is', 'my', 'first', 'text'). Will it work or is there any other 
catch I can not see.

My performance tests resulted that GIST would be slower than original 
btree index. Maybe I mistaken somehow...

Best regards,
David