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 73AF1529A5 for ; Tue, 9 Aug 2005 15:10: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 87007-09 for ; Tue, 9 Aug 2005 18:10:36 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.204]) by svr1.postgresql.org (Postfix) with ESMTP id 52749528E1 for ; Tue, 9 Aug 2005 15:10:33 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id i8so1269794wra for ; Tue, 09 Aug 2005 11:10:34 -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=kkJWikFPbgJsk4oitvXDz3LOhmdQ1eSfhBQpUZDRFDst6oFUIFAz2caMk1NUTpe5PcHHbo1EfuQsCKt0p4/vH8UN+5bkWXAJIVzDWVEYehAvPeJJoNBGbNWkmU1FOigNNE0JY/XO+bgQqq7b6Wugq8PCNIgk+Vm8StLo3/nhF10= Received: by 10.54.57.44 with SMTP id f44mr5757960wra; Tue, 09 Aug 2005 11:10:34 -0700 (PDT) Received: by 10.54.119.7 with HTTP; Tue, 9 Aug 2005 11:10:33 -0700 (PDT) Message-ID: <41b0fe89050809111027e1d274@mail.gmail.com> Date: Tue, 9 Aug 2005 11:10:33 -0700 From: Rhett Garber To: Tom Lane Subject: Re: Why hash join instead of nested loop? Cc: =?ISO-8859-1?Q?Havasv=F6lgyi_Ott=F3?= , pgsql-performance@postgresql.org In-Reply-To: <17253.1123607579@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <41b0fe890508051135712a086b@mail.gmail.com> <001801c59a0a$f4be7480$9a00a8c0@OTTO> <41b0fe8905080516164464e04f@mail.gmail.com> <15425.1123304631@sss.pgh.pa.us> <41b0fe89050808100021a2a4fc@mail.gmail.com> <10930.1123549106@sss.pgh.pa.us> <41b0fe890508090951546156f7@mail.gmail.com> <17253.1123607579@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200508/82 X-Sequence-Number: 13829 > I'm now thinking you've got either a platform- or compiler-specific > problem. Exactly what is the hardware (the CPU not the disks)? How did > you build or come by the Postgres executables (compiler, configure > options, etc)? I've tried it on two of our machines, both HP Proliant DL580: Production: Intel(R) Xeon(TM) MP CPU 2.80GHz (I think there are 2 physical CPUs with Hyperthreading, shows up as 4) 6 gigs RAM Development: Intel(R) XEON(TM) MP CPU 2.00GHz (I have vague recollection of disabling hyperthreading on this chip because of some other kernel issue) 1 gig RAM They are both running SuSE 8, 2.4.21-128-smp kernel Compile instructions (I didn't do it myself) indicate we built from source with nothing fancy: tar xpvf postgresql-7.4.1.tar.bz2 cd postgresql-7.4.1 ./configure --prefix=3D/usr/local/postgresql-7.4.1 make make install make install-all-headers If i run 'file' on /usr/local/postgresql-7.4.1/bin/postgres : postgres: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), dynamically linked (uses shared libs), not stripped Thanks for all your help guys, Rhett