Re: "between" is using index but "like" is not - Mailing list pgsql-novice

From Tom Lane
Subject Re: "between" is using index but "like" is not
Date
Msg-id 2065.1093460399@sss.pgh.pa.us
Whole thread Raw
In response to "between" is using index but "like" is not  (Jesper Krogh <jesper@krogh.cc>)
List pgsql-novice
Jesper Krogh <jesper@krogh.cc> writes:
> Why doesn't it use an index on the "like" operator when it doesn't
> contain a wildcard in the beginning of the pattern?

Probably because your locale isn't C --- locale-specific sort ordering
usually isn't compatible with the needs of LIKE, so we can only make
that optimization in C locale.

You can either re-initdb in C locale, or (if you're using 7.4) create a
specialized index with non-locale-dependent comparison operators.  See
the manual concerning specialized index operator classes.

            regards, tom lane

pgsql-novice by date:

Previous
From: Josh Berkus
Date:
Subject: Re: "between" is using index but "like" is not
Next
From: Gaetano Mendola
Date:
Subject: Re: "between" is using index but "like" is not