Trigram performance penalty on varchar?

From: Mario Lopez <mario(at)lar3d(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Trigram performance penalty on varchar?
Date: 2008-02-21 09:56:18
Message-ID: 47BD4AC2.2010703@lar3d.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 :)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Leahy 2008-02-21 10:02:29 No pgxs.mk with win32 binaries
Previous Message Stephen Davies 2008-02-21 09:46:31 Re: ts_headline