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 6121.1071805440@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: is it possible to get the optimizer to use indexes  (Dave Cramer <pg@fastcrypt.com>)
Ответы Re: is it possible to get the optimizer to use indexes
Список pgsql-performance
Дерево обсуждения 
Dave Cramer <pg@fastcrypt.com> writes:
> after vacuum verbose analyze, I still get [a seqscan]

The other gating factor is that you have to have initdb'd in C locale.
Non-C locales tend to use wild and wooly sort orders that are not
compatible with what LIKE needs.

            regards, tom lane

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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: is it possible to get the optimizer to use indexes
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: is it possible to get the optimizer to use indexes