Skip site navigation (1) Skip section navigation (2)

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

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>,pgsql-performance(at)postgresql(dot)org
Subject: Re: is it possible to get the optimizer to use indexes
Date: 2003-12-19 09:50:12
Message-ID: 1071827412.1627.25.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: 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(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

Responses

pgsql-performance by date

Next:From: Marinos J. YannikosDate: 2003-12-19 13:53:22
Subject: Re: why do optimizer parameters have to be set manually?
Previous:From: Tom LaneDate: 2003-12-19 03:44:00
Subject: Re: is it possible to get the optimizer to use indexes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group