Re: Very slow search using basic pattern matching - Mailing list pgsql-sql

Dan Field wrote:
> Is there any documentation available on how to go about creating these 
> indexes on my text fields?
> 
> I'm at a bit of a loss here, Google is failing me sadly

http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/

We made quite good experiences with tsearch2.
The problem for you could be that the case sensititity gets lost.

Raph