X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DC2B85293E for ; Sat, 2 Jul 2005 12:20:34 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 34842-07 for ; Sat, 2 Jul 2005 15:20:31 +0000 (GMT) Received: from tomts20-srv.bellnexxia.net (tomts20-srv.bellnexxia.net [209.226.175.74]) by svr1.postgresql.org (Postfix) with ESMTP id 5847D52923 for ; Sat, 2 Jul 2005 12:20:30 -0300 (ADT) Received: from [192.168.1.99] ([64.228.1.109]) by tomts20-srv.bellnexxia.net (InterMail vM.5.01.06.10 201-253-122-130-110-20040306) with ESMTP id <20050702152029.UYZG19894.tomts20-srv.bellnexxia.net@[192.168.1.99]>; Sat, 2 Jul 2005 11:20:29 -0400 Message-ID: <42C6B0B7.5010006@alteeve.com> Date: Sat, 02 Jul 2005 11:20:23 -0400 From: Madison Kelly User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.8) Gecko/20050513 Debian/1.7.8-1 X-Accept-Language: en-us, en, ja MIME-Version: 1.0 To: Tom Lane Cc: pgsql-performance@postgresql.org Subject: Re: B-Tree index not being used References: <42C61537.3080601@alteeve.com> <25042.1120312480@sss.pgh.pa.us> In-Reply-To: <25042.1120312480@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200507/16 X-Sequence-Number: 13257 Tom Lane wrote: > Madison Kelly writes: > >> Can anyone see why the index might not be being used? > > > You didn't initdb in 'C' locale. You can either re-initdb, > or create a specialized index with a non-default operator class > to support LIKE. See the documentation. > > regards, tom lane I'll look into the non-default op class. I want to keep anything that tweaks the DB in my code so that a user doesn't need to modify anything on their system. Thanks! Madison -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Madison Kelly (Digimer) TLE-BU, The Linux Experience; Back Up http://tle-bu.thelinuxexperience.com -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-