X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id CBE704758F1 for ; Sat, 29 Mar 2003 11:48:34 -0500 (EST) Received: from mail3.centurytel.net (mail3.centurytel.net [209.142.136.99]) by postgresql.org (Postfix) with ESMTP id 0E235474E42 for ; Sat, 29 Mar 2003 11:48:30 -0500 (EST) Received: from localhost.localdomain (pppoe0716.grp.centurytel.net [64.91.27.209]) by mail3.centurytel.net (8.12.8/8.12.8) with ESMTP id h2TGmYTP017135 for ; Sat, 29 Mar 2003 10:48:34 -0600 (CST) Content-Type: text/plain; charset="iso-8859-1" From: "John K. Herreshoff" To: pgsql-performance@postgresql.org Subject: Re: Index not used, performance problem Date: Sat, 29 Mar 2003 11:49:00 -0500 User-Agent: KMail/1.4.3 References: <1048931358.7539.11.camel@andi-lap> <20030329214139.N4697-100000@houston.familyhealth.com.au> <20030329103452.B16250@mail.libertyrms.com> In-Reply-To: <20030329103452.B16250@mail.libertyrms.com> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200303291149.00790.jkherr@centurytel.net> X-Spam-Status: No, hits=-38.1 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_KMAIL 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/191 X-Sequence-Number: 1489 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