Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 220C29FB31C for ; Wed, 4 Oct 2006 11:05:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 28479-03 for ; Wed, 4 Oct 2006 11:05:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by postgresql.org (Postfix) with ESMTP id B030E9FB31A for ; Wed, 4 Oct 2006 11:05:28 -0300 (ADT) Received: from mainbox.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id 3EE2F74A81; Wed, 4 Oct 2006 15:04:37 +0100 (BST) Received: from [192.168.1.17] (client17.office.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id CA3D115EA3; Wed, 4 Oct 2006 15:04:36 +0100 (BST) Message-ID: <4523C007.4050606@archonet.com> Date: Wed, 04 Oct 2006 15:07:03 +0100 From: Richard Huxton User-Agent: Thunderbird 1.5.0.7 (X11/20060909) MIME-Version: 1.0 To: simon godden Cc: Postgresql Performance Subject: Re: simple case using index on windows but not on linux References: <168519350610040048m7c4031e3t1a24b3fd4d9265a3@mail.gmail.com> <45237AD0.50604@enterprisedb.com> <168519350610040219n648a282hf159ff272e0f672a@mail.gmail.com> <45238085.3000407@archonet.com> <168519350610040240k346bd99fj9537822d79443f8c@mail.gmail.com> <45238F54.70609@archonet.com> <168519350610040635r4d041bd7vba47ca0e31a4c7d0@mail.gmail.com> <4523BB75.9020200@archonet.com> <168519350610040647v395f1aeag8e9c6825ad25320e@mail.gmail.com> In-Reply-To: <168519350610040647v395f1aeag8e9c6825ad25320e@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.475 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200610/86 X-Sequence-Number: 21215 simon godden wrote: > On 10/4/06, Richard Huxton wrote: >> simon godden wrote: >> >> From psql, a "show all" command will list all your config settings and >> let you check the lc_xxx values are correct. > > lc_collate is C, as are all the other lc settings. > > I have run the analyze commands. > > Still the same. Can you post EXPLAIN ANALYSE for the LIKE and <> queries that should be using the index? With enable_seqscan on and off please. -- Richard Huxton Archonet Ltd