Re: Index not used, performance problem

From: "John K(dot) Herreshoff" <jkherr(at)centurytel(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Index not used, performance problem
Date: 2003-03-29 16:49:00
Message-ID: 200303291149.00790.jkherr@centurytel.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

In Linux (Redhat) where, exactly, does one set the LOCALE to C?

TIA :-)

John.

On Saturday 29 March 2003 10:34 am, Andrew Sullivan wrote:
> On Sat, Mar 29, 2003 at 09:47:51PM +0800, Christopher Kings-Lynne wrote:
> > the form 'FOO%', which is what you are doing. However, I believe that
> > PostgreSQL cannot do this if your database encoding is anything other
> > than 'C'. So, if you are using an Austrian encoding, it might not be
> > able to
>
> That is, you need to have had the LOCALE set to 'C' when you did
> initdb. It's not enough to change it afterwards.
>
> A

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andreas Kostyrka 2003-03-29 16:57:58 Re: Index not used, performance problem
Previous Message Andrew Sullivan 2003-03-29 15:34:52 Re: Index not used, performance problem