From: Josh Berkus <josh@agliodbs.com>
Reply-To: josh@agliodbs.com
Organization: Aglio Database Solutions
To: pgsql-performance@postgresql.org
Subject: Re: Performance problems on 4/8way Opteron (dualcore) HP DL585
Date: Fri, 29 Jul 2005 10:46:10 -0700
User-Agent: KMail/1.8
Cc: Dirk =?iso-8859-1?q?Lutzeb=E4ck?= <lutzeb@aeccom.com>,
	Sven Geisler <sgeisler@aeccom.com>
References: <42EA5D18.9020204@aeccom.com>
In-Reply-To: <42EA5D18.9020204@aeccom.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200507291046.10318.josh@agliodbs.com>

Dirk,

> does anybody have expierence with this machine (4x 875 dual core Opteron
> CPUs)?

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.

> 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?

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco