Trigram performance penalty on varchar? - Mailing list pgsql-general

From Mario Lopez
Subject Trigram performance penalty on varchar?
Date
Msg-id 47BD4AC2.2010703@lar3d.com
Whole thread Raw
Responses Re: Trigram performance penalty on varchar?
List pgsql-general
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 wrong...

Thanks :)

pgsql-general by date:

Previous
From: Stephen Davies
Date:
Subject: Re: ts_headline
Next
From: Mike Leahy
Date:
Subject: No pgxs.mk with win32 binaries