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

Re: High CPU Utilization

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Ron <rjpeace(at)earthlink(dot)net>
Cc: Joe Uhl <joeuhl(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: High CPU Utilization
Date: 2009-03-24 23:16:30
Message-ID: dcc563d10903241616l2c16e803q7f327e4d7aaf5c43@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Tue, Mar 24, 2009 at 4:58 PM, Ron <rjpeace(at)earthlink(dot)net> wrote:
> At 02:47 PM 3/24/2009, Joe Uhl wrote:
>
>> Turns out we may have an opportunity to purchase a new database server
>> with this increased load.  Seems that the best route, based on feedback to
>> this thread, is to go whitebox, get quad opterons, and get a very good disk
>> controller.
>>
>> Can anyone recommend a whitebox vendor?
>
> I'll 2nd the Aberdeen recommendation.  I'll add Pogolinux to that list as
> well.
>
>
>> Is there a current controller anyone on this list has experience with that
>> they could recommend?
>
> The 2 best performing RAID controller vendors at this time are AMCC (AKA
> 3Ware) and Areca.
> In general, the 8+ port Areca's with their BB cache maxed outperform every
> other controller available.
>
>
>> This will be a bigger purchase so will be doing research and benchmarking
>> but any general pointers to a vendor/controller greatly appreciated.
>
> Be =very= careful to thoroughly bench both the AMD and Intel CPU options.
>  It is far from clear which is the better purchase.

My anecdotal experience has been that the Opterons stay afloat longer
as load increases, but I haven't had machines with similar enough
hardware to really test that.

> I'd be very interested to see the results of your research and benchmarks
> posted here on pgsql-performance.

Me too.  I'm gonna spend some time this summer benchmarking and tuning
the database servers that I pretty much had to burn in and put in
production this year due to time pressures.

In response to

Responses

pgsql-performance by date

Next:From: Scott CareyDate: 2009-03-25 00:22:24
Subject: Re: High CPU Utilization
Previous:From: RonDate: 2009-03-24 22:58:13
Subject: Re: High CPU Utilization

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