X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id AB57FD1D74D for ; Wed, 12 May 2004 05:07:41 -0300 (ADT) 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 75244-06 for ; Wed, 12 May 2004 05:07:23 -0300 (ADT) Received: from mail.census.gov.ph (mail.census.gov.ph [203.172.28.120]) by svr1.postgresql.org (Postfix) with ESMTP id 56C99D1D75B for ; Wed, 12 May 2004 05:06:58 -0300 (ADT) Received: from notnot (gateway.census.gov.ph [203.172.28.97]) by mail.census.gov.ph (8.12.8/8.12.8) with ESMTP id i4C84gh9004444; Wed, 12 May 2004 16:04:50 +0800 Message-Id: <200405120804.i4C84gh9004444@mail.census.gov.ph> From: "Michael Ryan S. Puncia" To: "'Christopher Kings-Lynne'" , "'Michael Ryan S. Puncia'" Cc: Subject: Re: Using LIKE expression problem.. Date: Wed, 12 May 2004 16:17:36 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: AcQ39pCP+kPy71w1QX2Ob2hZdib3tgAApX5g In-Reply-To: <40A1D94E.9030605@familyhealth.com.au> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-MailScanner: Found to be clean by NSO mail server. X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/109 X-Sequence-Number: 6940 Sorry .. I am a newbie and I don't know :( How can I know that I am in C locale ? How can I change my database to use C locale? -----Original Message----- From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Christopher Kings-Lynne Sent: Wednesday, May 12, 2004 3:59 PM To: Michael Ryan S. Puncia Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Using LIKE expression problem.. Are you in a non-C locale? Chris Michael Ryan S. Puncia wrote: > Yes , I already do that but the same result .. LIKE uses seq scan > > -----Original Message----- > From: pgsql-performance-owner@postgresql.org > [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Christopher > Kings-Lynne > Sent: Wednesday, May 12, 2004 2:48 PM > To: Michael Ryan S. Puncia > Cc: pgsql-performance@postgresql.org > Subject: Re: [PERFORM] Using LIKE expression problem.. > > >>In the query plan ..it uses seq scan rather than index scan .. why ? I >>have index on lastname, firtname. > > > Have you run VACUUM ANALYZE; on the table recently? > > Chris > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html