X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 12893475EE2 for ; Sat, 29 Mar 2003 11:58:25 -0500 (EST) Received: from indygecko.com (h24-77-222-182.ok.shawcable.net [24.77.222.182]) by postgresql.org (Postfix) with ESMTP id 0A2A8475ECE for ; Sat, 29 Mar 2003 11:58:24 -0500 (EST) Received: from [192.168.10.10] ([::ffff:192.168.10.10]) by indygecko.com with esmtp; Sat, 29 Mar 2003 08:58:27 -0800 Subject: Re: Index not used, performance problem From: Jord Tanner To: "John K. Herreshoff" Cc: pgsql-performance@postgresql.org In-Reply-To: <200303291149.00790.jkherr@centurytel.net> References: <1048931358.7539.11.camel@andi-lap> <20030329214139.N4697-100000@houston.familyhealth.com.au> <20030329103452.B16250@mail.libertyrms.com> <200303291149.00790.jkherr@centurytel.net> Organization: Message-Id: <1048957169.7512.33.camel@gecko> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.2.3 Date: 29 Mar 2003 08:59:29 -0800 X-Spam-Status: No, hits=-38.0 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_XIMIAN autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200303/193 X-Sequence-Number: 1491 # 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@postgresql.org so that your > message can get through to the mailing list cleanly -- Jord Tanner