Re: like performance w/o wildcards.

Поиск
Список
Период
Сортировка
От Joseph Shraibman
Тема Re: like performance w/o wildcards.
Дата
Msg-id 3F2EFEEC.2090106@selectacast.net
обсуждение исходный текст
Ответ на Re: like performance w/o wildcards.  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: like performance w/o wildcards.  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-general
Tom Lane wrote:
> Joseph Shraibman <jks@selectacast.net> writes:
>
>>What percentage of locales have this problem?  Does latin1 have this problem?
>
>
> Latin1 is an encoding, not a locale.  To a first approximation, I'd say
> *all* non-C locales have some kind of sorting funny business.
>
OK this clears things up a bit.  The locale on my production server (redhat) is set to
en_US, which explains why LIKE doesn't use an index.  Do I just have to reset the locale
environment variable and restart postgres?  What might the side effects of that be?


>
>>And what about my original idea, can LIKE be turned into an = when there are no wildcards?
>
>
> It does ... if the index-conversion optimization is enabled at all.

Sorry, what is 'index-conversion optimization' and when is it enabled?


В списке pgsql-general по дате отправления:

Предыдущее
От: "Roderick A. Anderson"
Дата:
Сообщение: Re: varchar, text and cidr
Следующее
От: Richard Welty
Дата:
Сообщение: Re: varchar, text and cidr