X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A491AD1B486 for ; Fri, 19 Dec 2003 09:51:08 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 71215-09 for ; Fri, 19 Dec 2003 05:50:20 -0400 (AST) Received: from net2.micro-automation.com (net2.micro-automation.com [64.7.141.29]) by svr1.postgresql.org (Postfix) with SMTP id A76B5D1B48F for ; Fri, 19 Dec 2003 05:50:17 -0400 (AST) Received: (qmail 7249 invoked from network); 19 Dec 2003 09:50:13 -0000 Received: from dcdsl.ebox.com (HELO ?192.168.1.36?) (davec@64.7.143.116) by net2.micro-automation.com with SMTP; 19 Dec 2003 09:50:13 -0000 Subject: Re: is it possible to get the optimizer to use indexes From: Dave Cramer Reply-To: pg@fastcrypt.com To: Tom Lane Cc: Christopher Kings-Lynne , pgsql-performance@postgresql.org In-Reply-To: <6121.1071805440@sss.pgh.pa.us> References: <3FE1F5A1.6080908@geizhals.at> <60n09q9bqg.fsf@dev6.int.libertyrms.info> <1071789528.1629.10.camel@localhost.localdomain> <3FE256AA.8000707@familyhealth.com.au> <1071803317.1629.16.camel@localhost.localdomain> <6121.1071805440@sss.pgh.pa.us> Content-Type: text/plain Organization: Cramer Consulting Message-Id: <1071827412.1627.25.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.2 (1.2.2-5) Date: 19 Dec 2003 04:50:12 -0500 Content-Transfer-Encoding: 7bit X-AntiVirus: scanned for viruses by AMaViS 0.2.1 (http://amavis.org/) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/273 X-Sequence-Number: 5133 So even in a north-american locale, such as en_CA this will be a problem? Dave On Thu, 2003-12-18 at 22:44, Tom Lane wrote: > Dave Cramer writes: > > after vacuum verbose analyze, I still get [a seqscan] > > The other gating factor is that you have to have initdb'd in C locale. > Non-C locales tend to use wild and wooly sort orders that are not > compatible with what LIKE needs. > > regards, tom lane > >