X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C4C53D9306 for ; Fri, 23 Sep 2005 14:15:45 -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 24401-07 for ; Fri, 23 Sep 2005 17:15:42 +0000 (GMT) Received: from ecmailer.ecmarket.com (ecmailer.ecmarket.com [216.187.109.2]) by svr1.postgresql.org (Postfix) with ESMTP id B9166D9305 for ; Fri, 23 Sep 2005 14:15:39 -0300 (ADT) Received: from hummer.enterprise.ecmarket.com (hummer.enterprise.ecmarket.com [10.0.7.2]) by ecmailer.ecmarket.com (Postfix) with ESMTP id CD8EDB81B8 for ; Fri, 23 Sep 2005 10:15:36 -0700 (PDT) Received: from gurpreet2 (gaulakh2.devel.ecmarket.com [10.0.5.33]) by hummer.enterprise.ecmarket.com (Postfix) with SMTP id CE09A2416E for ; Fri, 23 Sep 2005 10:15:34 -0700 (PDT) From: "Gurpreet Aulakh" To: Subject: Re: Query slower on 8.0.3 (Windows) vs 7.3 (cygwin) Date: Fri, 23 Sep 2005 10:15:36 -0700 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 In-Reply-To: <24008.1127358777@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200509/308 X-Sequence-Number: 14616 After further investigation I have found that the reason why the query is slower on 8.0.3 is that the hash and hash joins are slower on the 8.0.3. So the question comes down to : Why are hash and hash joins slower? Is this a postgres configuration setting that I am missing? Is the locale still screwing me up? I have set the locale to 'C' without any improvements. Is it because the column type is a varchar that the hash is slower?