Skip site navigation (1) Skip section navigation (2)

Re: Performance problems on 4/8way Opteron (dualcore) HP

From: "Jeffrey W(dot) Baker" <jwbaker(at)acm(dot)org>
To: josh(at)agliodbs(dot)com
Cc: pgsql-performance(at)postgresql(dot)org,Dirk Lutzebäck <lutzeb(at)aeccom(dot)com>,Sven Geisler <sgeisler(at)aeccom(dot)com>
Subject: Re: Performance problems on 4/8way Opteron (dualcore) HP
Date: 2005-07-29 18:55:42
Message-ID: 1122663342.6814.5.camel@toonses.gghcwest.com (view raw or flat)
Thread:
Lists: pgsql-performance
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?
> 

In response to

Responses

pgsql-performance by date

Next:From: Luke LonerganDate: 2005-07-29 19:02:30
Subject: Re: Performance problems testing with Spamassassin
Previous:From: John Arbash MeinelDate: 2005-07-29 18:29:46
Subject: Re: Performance problems testing with Spamassassin 3.1.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group