From: | Jord Tanner <jord(at)indygecko(dot)com> |
---|---|
To: | "John K(dot) Herreshoff" <jkherr(at)centurytel(dot)net> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Index not used, performance problem |
Date: | 2003-03-29 16:59:29 |
Message-ID: | 1048957169.7512.33.camel@gecko |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
# su postgres
% export LANG=C
% /usr/local/pgsql/bin/initdb blah blah
That always works for me!
On Sat, 2003-03-29 at 08:49, John K. Herreshoff wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
--
Jord Tanner <jord(at)indygecko(dot)com>
From | Date | Subject | |
---|---|---|---|
Next Message | Matt Mello | 2003-03-29 17:55:00 | Re: Index not used, performance problem |
Previous Message | Andreas Kostyrka | 2003-03-29 16:59:11 | Re: Index not used, performance problem |