So even in a north-american locale, such as en_CA this will be a
On Thu, 2003-12-18 at 22:44, Tom Lane wrote:
> Dave Cramer <pg(at)fastcrypt(dot)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
In response to
pgsql-performance by date
|Next:||From: Marinos J. Yannikos||Date: 2003-12-19 13:53:22|
|Subject: Re: why do optimizer parameters have to be set manually?|
|Previous:||From: Tom Lane||Date: 2003-12-19 03:44:00|
|Subject: Re: is it possible to get the optimizer to use indexes |