Re: is it possible to get the optimizer to use indexes - Mailing list pgsql-performance

From Dave Cramer
Subject Re: is it possible to get the optimizer to use indexes
Date
Msg-id 1071827412.1627.25.camel@localhost.localdomain
Whole thread Raw
In response to Re: is it possible to get the optimizer to use indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: is it possible to get the optimizer to use indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: is it possible to get the optimizer to use indexes
Next
From: "Marinos J. Yannikos"
Date:
Subject: Re: why do optimizer parameters have to be set manually?