| From: | Arthur Zakirov <a(dot)zakirov(at)postgrespro(dot)ru> |
|---|---|
| To: | Jeffrey Kamei <jeff(at)windfalldata(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: <-> Operator on Trigram Index |
| Date: | 2018-11-15 09:28:16 |
| Message-ID: | dda9c633-6628-b3a3-78e6-0dc7bb279b82@postgrespro.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
On 14.11.2018 01:42, Jeffrey Kamei wrote:
> I'm trying to get the <-> operator to recognize a trigram index (GIST)
> I've set on a table. Using `EXPLAIN VERBOSE` I can see the query engine
> ignoring the trigram index when using the `<->` operator. However if I
> use the `%` operator, the index is found and used. Can you explain why
> this is happening? As far as I can tell from the documentation, the
> `<->` operator should be using the index as well.
Yes <-> operator should use a GiST index. Can you show your query and
its plan?
--
Arthur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Lawrence Barwick | 2018-11-15 12:05:37 | Re: VM Instance to Google Cloud SQL Migration |
| Previous Message | Andreas Kretschmer | 2018-11-15 08:19:39 | Re: VM Instance to Google Cloud SQL Migration |