Re: Performance problems on 4-way AMD Opteron 875 (dual core)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dirk Lutzebäck <lutzeb(at)aeccom(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org, Sven Geisler <sgeisler(at)aeccom(dot)com>
Subject: Re: Performance problems on 4-way AMD Opteron 875 (dual core)
Date: 2005-08-05 13:53:14
Message-ID: 8258.1123249994@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <lutzeb(at)aeccom(dot)com> writes:
> Here are the number of queries which the server has finished in a fix
> period of time.

Uh, you never actually supplied any numbers (or much of any other
specifics about what was tested, either).

My first reaction is "don't vary more than one experimental parameter at
a time". There is no way to tell whether the discrepancy is due to the
different hardware, different Postgres version, or 32-bit vs 64-bit
build.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Rhett Garber 2005-08-05 18:35:03 Why hash join instead of nested loop?
Previous Message Dirk Lutzebäck 2005-08-05 12:56:23 Re: Performance problems on 4-way AMD Opteron 875 (dual