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

Поиск
Список
Период
Сортировка
От Tomaz Borstnar
Тема This locale setting will prevent use of index optimization for LIKE and regexp searches. (sl_SI.ISO_8859-2)
Дата
Msg-id 5.0.2.1.0.20001227112041.02f867e0@193.189.189.100
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: List metadata tags (was Re: Auto Increment)
Следующее
От: Alvaro Herrera
Дата:
Сообщение: SSL