Re: How to boost performance of queries containing pattern matching characters - Mailing list pgsql-performance

> Looks like you've almost re-invented the trigram module:
>   http://www.postgresql.org/docs/9.0/static/pgtrgm.html

I didn't know about this module.
Idea to use three letters strings and use Full Text Search is the same, but
the rest is not.

Is the idea to use similarity for this problem is really correct? How should
be query constructed to return really all records matching ILIKE criteria?


-------------------------------------------
Artur Zajac