On Thu, Dec 18, 2014 at 10:00 AM, Giuseppe Broccolo < giuseppe.brocc...@2ndquadrant.it> wrote: > > I'm not sure about the '%' operator, but I'm sure that the GIST index will > never be used in the > > SELECT * FROM users WHERE lower(name) LIKE '%john%'; > > query; it is used for left or right anchored search, such as 'john%' or > '%john'. >
The point of the gist_trgm_ops operator is specifically to overcome that limitation. It is pretty awesome. Cheers, Jeff > >