From: Jeffrey W. Baker <jwbaker@acm.org>
To: josh@agliodbs.com
Cc: pgsql-performance@postgresql.org, Dirk Lutzebäck <lutzeb@aeccom.com>
Cc: Sven Geisler <sgeisler@aeccom.com>
Subject: Re: Performance problems on 4/8way Opteron (dualcore) HP
Date: Fri, 29 Jul 2005 11:55:42 -0700
Message-ID: <1122663342.6814.5.camel@toonses.gghcwest.com> (raw)
In-Reply-To: <200507291046.10318.josh@agliodbs.com>
References: <42EA5D18.9020204@aeccom.com>
<200507291046.10318.josh@agliodbs.com>
On Fri, 2005-07-29 at 10:46 -0700, Josh Berkus wrote:
> Dirk,
>
> > does anybody have expierence with this machine (4x 875 dual core Opteron
> > CPUs)?
I'm using dual 275s without problems.
> Nope. I suspect that you may be the first person to report in on
> dual-cores. There may be special compile issues with dual-cores that
> we've not yet encountered.
Doubtful. However you could see improvements using recent Linux kernel
code. There have been some patches for optimizing scheduling and memory
allocations.
However, if you are running this machine in 32-bit mode, why did you
bother paying $14,000 for your CPUs? You will get FAR better
performance in 64-bit mode. 64-bit mode will give you 30-50% better
performance on PostgreSQL loads, in my experience. Also, if I remember
correctly, the 32-bit x86 kernel doesn't understand Opteron NUMA
topology, so you may be seeing poor memory allocation decisions.
-jwb
> > We run RHEL 3.0, 32bit and under high load it is a drag. We
> > mostly run memory demanding queries. Context switches are pretty much
> > around 20.000 on the average, no cs spikes when we run many processes in
> > parallel. Actually we only see two processes in running state! When
> > there are only a few processes running context switches go much higher.
> > At the moment we are much slower that with a 4way XEON box (DL580).
>
> Um, that was a bit incoherent. Are you seeing a CS storm or aren't you?
>
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: jwbaker@acm.org, josh@agliodbs.com, lutzeb@aeccom.com, sgeisler@aeccom.com
Subject: Re: Performance problems on 4/8way Opteron (dualcore) HP
In-Reply-To: <1122663342.6814.5.camel@toonses.gghcwest.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