Re: Behavior of a pg_trgm index for 2 (or < 3) character LIKE queries
| От | Alexander Korotkov |
|---|---|
| Тема | Re: Behavior of a pg_trgm index for 2 (or < 3) character LIKE queries |
| Дата | |
| Msg-id | CAPpHfdtGkbXjrPkxziRdc9dNnurGAYgivYLNV0_LoBQ329fS7A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Behavior of a pg_trgm index for 2 (or < 3) character LIKE queries (Sawada Masahiko <sawada.mshk@gmail.com>) |
| Ответы |
Re: Behavior of a pg_trgm index for 2 (or < 3) character
LIKE queries
Re: Behavior of a pg_trgm index for 2 (or < 3) character LIKE queries |
| Список | pgsql-hackers |
On Thu, May 30, 2013 at 12:49 PM, Sawada Masahiko <sawada.mshk@gmail.com> wrote:
------
With best regards,
Alexander Korotkov.
following emails are discussed about partial match of pg_trgm. I hopewill this help.
<http://www.postgresql.org/message-id/CAHGQGwFJshvV2nGME19wdTW9teFw_w7h2ns4E+YYsjkB9WdWDQ@mail.gmail.com>
as you may know, if search string contains multibyte characters
trigram key is converted to CRC of 4 byte and it is used as key.
(but only use upper 3 byte from CRC)
so we can do partial matching if KEEPONLYALNUM is enabled.
Please, read the further discussion on that thread. We can't do partial matching because of CRC independently of KEEPONLYALNUM.
With best regards,
Alexander Korotkov.
В списке pgsql-hackers по дате отправления: