Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id AA1649FB38C for ; Wed, 4 Oct 2006 11:49:03 -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 51573-09 for ; Wed, 4 Oct 2006 11:48:55 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.235]) by postgresql.org (Postfix) with ESMTP id 4860C9FB36F for ; Wed, 4 Oct 2006 11:48:55 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id i21so27209wra for ; Wed, 04 Oct 2006 07:48:53 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=GxdqsfMS8L7snuPC7fMj5hKULjbsApKT2vDCLLJPLtxSSX7p/jhuMw6km8753lU/LLonfDKT9RCdfd3XWUyPNyyojFYCka8Q2MJqr4z25LNJ3InrR5gaQR+Lh1E7FNfwKTI2JuRewbYfNwjA+oEi37GvCLW/AdDGZs6p34dtuu4= Received: by 10.48.242.19 with SMTP id p19mr2452931nfh; Wed, 04 Oct 2006 07:48:52 -0700 (PDT) Received: by 10.49.12.13 with HTTP; Wed, 4 Oct 2006 07:48:52 -0700 (PDT) Message-ID: <168519350610040748q6948ef9es7bd8b6d0c50e623c@mail.gmail.com> Date: Wed, 4 Oct 2006 15:48:52 +0100 From: "simon godden" To: "Richard Huxton" Subject: Re: simple case using index on windows but not on linux Cc: "Postgresql Performance" In-Reply-To: <168519350610040746q64804cbcr6d73e1dd4e8592d7@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <168519350610040048m7c4031e3t1a24b3fd4d9265a3@mail.gmail.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> <4523C007.4050606@archonet.com> <168519350610040746q64804cbcr6d73e1dd4e8592d7@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.174 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, SPF_PASS X-Spam-Level: X-Archive-Number: 200610/89 X-Sequence-Number: 21218 I think I am being stupid now. The > query was returning so many rows (87% of the rows in the table) that a seq-scan was of course the best way. Sorry - all is now working and the problem was the locale issue. Thanks so much for your help everyone. -- Simon Godden