Postgres Pro
Downloads
Home   >   mailing lists

Re: Question about trigram GIST index - Mailing list pgsql-performance

From Giuseppe Broccolo
Subject Re: Question about trigram GIST index
Date
Msg-id CAFzmHiXNZUU36WBPLSJY9gDfHrqSjBOZkNOLXHgS8ASV=4wZZw@mail.gmail.com
Whole thread Raw
In response to Re: Question about trigram GIST index  (Robert DiFalco <robert.difalco@gmail.com>)
Responses Re: Question about trigram GIST index
Re: Question about trigram GIST index
Re: Question about trigram GIST index
List pgsql-performance
Tree view
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'.

Giuseppe.
--
Giuseppe Broccolo - 2ndQuadrant Italy
PostgreSQL Training, Services and Support
giuseppe.broccolo@2ndQuadrant.it | www.2ndQuadrant.it

pgsql-performance by date:

Previous
From: Robert DiFalco
Date:
Subject: Re: Question about trigram GIST index
Next
From: Robert DiFalco
Date:
Subject: Re: Question about trigram GIST index