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

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

Dave
On Thu, 2003-12-18 at 22:44, Tom Lane wrote:
> 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 по дате отправления:

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