On Thu, Dec 18, 2014 at 10:00 AM, Giuseppe Broccolo <giuseppe.broccolo@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
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'.
pgsql-performance by date:
Соглашаюсь с условиями обработки персональных данных