X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0BBCA475A45 for ; Sat, 29 Mar 2003 10:34:49 -0500 (EST) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by postgresql.org (Postfix) with ESMTP id 220B8474E42 for ; Sat, 29 Mar 2003 10:34:48 -0500 (EST) Received: from andrew by mail.libertyrms.com with local (Exim 3.22 #3 (Debian)) id 18zIM8-0004Ky-00 for ; Sat, 29 Mar 2003 10:34:52 -0500 Date: Sat, 29 Mar 2003 10:34:52 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Index not used, performance problem Message-ID: <20030329103452.B16250@mail.libertyrms.com> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <1048931358.7539.11.camel@andi-lap> <20030329214139.N4697-100000@houston.familyhealth.com.au> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20030329214139.N4697-100000@houston.familyhealth.com.au>; from chriskl@familyhealth.com.au on Sat, Mar 29, 2003 at 09:47:51PM +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_MUTT 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/190 X-Sequence-Number: 1488 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 -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110