From: Rhett Garber <rhettg@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Havasvölgyi Ottó <h.otto@freemail.hu>
Cc: pgsql-performance@postgresql.org
Subject: Re: Why hash join instead of nested loop?
Date: Tue, 9 Aug 2005 11:10:33 -0700
Message-ID: <41b0fe89050809111027e1d274@mail.gmail.com> (raw)
In-Reply-To: <17253.1123607579@sss.pgh.pa.us>
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>
> 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=/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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: rhettg@gmail.com, tgl@sss.pgh.pa.us, h.otto@freemail.hu
Subject: Re: Why hash join instead of nested loop?
In-Reply-To: <41b0fe89050809111027e1d274@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox