Re: is it possible to get the optimizer to use indexes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: is it possible to get the optimizer to use indexes
Дата
Msg-id 9224.1071844694@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: is it possible to get the optimizer to use indexes  (Dave Cramer <pg@fastcrypt.com>)
Список pgsql-performance
Dave Cramer <pg@fastcrypt.com> writes:
> So even in a north-american locale, such as en_CA this will be a
> problem?

If it's not "C" we won't try to optimize LIKE.  I know en_US does not
work (case-insensitive, funny rules about spaces, etc) and I would
expect en_CA has the same issues.

If you're using 7.4 you have the option to create a special index
instead of re-initdb'ing your whole database.

            regards, tom lane

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

Предыдущее
От: "Marinos J. Yannikos"
Дата:
Сообщение: Re: why do optimizer parameters have to be set manually?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: why do optimizer parameters have to be set manually?