Re: [GENERAL] Trigram performance penalty on varchar?

2008-02-24 Thread Alban Hertroys
On Feb 21, 2008, at 10:56 AM, Mario Lopez wrote: Hi, I am indexing a 100 million record table composed of varchar(255) as the field to be indexed. I have always seen that examples of pg_trgm are based on text type fields. Is this by any special reason?. A varchar is internally

[GENERAL] Trigram performance penalty on varchar?

2008-02-21 Thread Mario Lopez
Hi, I am indexing a 100 million record table composed of varchar(255) as the field to be indexed. I have always seen that examples of pg_trgm are based on text type fields. Is this by any special reason?. My computer is creating the index since 5 hours ago so I guess there must be something