Thread: This locale setting will prevent use of index optimization for LIKE and regexp searches. (sl_SI.ISO_8859-2)

Hello!

    Installed 7.1beta1, set LC_ALL to sl_SI.ISO_8859-2 and initialized the
database with initdb and got this:

NOTICE:  Initializing database with sl_SI.ISO_8859-2 collation order.
         This locale setting will prevent use of index optimization for
         LIKE and regexp searches.  If you are concerned about speed of
         such queries, you may wish to set LC_COLLATE to "C" and
         re-initdb.  For more information see the Administrator's Guide.


How much can this affect and if there is any way to make this as fast as
possible?

Tomaz