Postgres Pro
Downloads
Home   >   mailing lists

Re: Behavior of a pg_trgm index for 2 (or < 3) character LIKE queries - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Behavior of a pg_trgm index for 2 (or < 3) character LIKE queries
Date
Msg-id CA+TgmobvsL35sRPJ8BjHgTkPMZssTL03iO4xY2nMkxje0t5XxQ@mail.gmail.com
Whole thread Raw
In response to Behavior of a pg_trgm index for 2 (or < 3) character LIKE queries  (Amit Langote <amitlangote09@gmail.com>)
Responses Re: Behavior of a pg_trgm index for 2 (or < 3) character LIKE queries  (Amit Langote <amitlangote09@gmail.com>)
List pgsql-hackers
Tree view 
On Wed, May 29, 2013 at 10:51 PM, Amit Langote <amitlangote09@gmail.com> wrote:
> So, it appears, for search strings consisting of 2 (or < 3)
> characters, trigrams can not be utilized. No?

I think that's right.  "trigram" means a sequence of three characters,
and what's stored in the indexes are three-character sequences from
the original text.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: pg_dump with postgis extension dumps rules separately
Next
From: Amit Langote
Date:
Subject: Re: Behavior of a pg_trgm index for 2 (or < 3) character LIKE queries