This locale setting will prevent use of index optimization for LIKE and regexp searches. (sl_SI.ISO_8859-2) - Mailing list pgsql-general

From Tomaz Borstnar
Subject This locale setting will prevent use of index optimization for LIKE and regexp searches. (sl_SI.ISO_8859-2)
Date
Msg-id 5.0.2.1.0.20001227112041.02f867e0@193.189.189.100
Whole thread Raw
List pgsql-general
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


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: List metadata tags (was Re: Auto Increment)
Next
From: Alvaro Herrera
Date:
Subject: SSL