From: Scott Marlowe <scott.marlowe@gmail.com>
To: Ron <rjpeace@earthlink.net>
Cc: Joe Uhl <joeuhl@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: High CPU Utilization
Date: Tue, 24 Mar 2009 17:16:30 -0600
Message-ID: <dcc563d10903241616l2c16e803q7f327e4d7aaf5c43@mail.gmail.com> (raw)
In-Reply-To: <E1LmFZX-0006RF-Tt@elasmtp-curtail.atl.sa.earthlink.net>
References: <8609D1C0-3ECD-4A4F-B9C6-1FC8496EDC7A@gmail.com>
<alpine.GSO.2.01.0903161621230.3428@westnet.com>
<87d4ch0z4z.fsf@oxford.xeocode.com>
<alpine.GSO.2.01.0903170017410.5259@westnet.com>
<9719B46B-6CF8-4710-BE2A-1DE8E1C0C05B@gmail.com>
<dcc563d10903201329l7ea173bcg76a06f5cce082bdb@mail.gmail.com>
<468A01CE-F631-4B2F-8882-03C381503DA2@gmail.com>
<dcc563d10903201358w2e13f785n588809ed8f6d0bdc@mail.gmail.com>
<1E10954A-136D-4E1E-B576-31D09EE46499@gmail.com>
<E1LmFZX-0006RF-Tt@elasmtp-curtail.atl.sa.earthlink.net>
On Tue, Mar 24, 2009 at 4:58 PM, Ron <rjpeace@earthlink.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.
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: scott.marlowe@gmail.com, rjpeace@earthlink.net, joeuhl@gmail.com
Subject: Re: High CPU Utilization
In-Reply-To: <dcc563d10903241616l2c16e803q7f327e4d7aaf5c43@mail.gmail.com>
References: <8609D1C0-3ECD-4A4F-B9C6-1FC8496EDC7A@gmail.com> <alpine.GSO.2.01.0903161621230.3428@westnet.com> <87d4ch0z4z.fsf@oxford.xeocode.com> <alpine.GSO.2.01.0903170017410.5259@westnet.com> <9719B46B-6CF8-4710-BE2A-1DE8E1C0C05B@gmail.com> <dcc563d10903201329l7ea173bcg76a06f5cce082bdb@mail.gmail.com> <468A01CE-F631-4B2F-8882-03C381503DA2@gmail.com> <dcc563d10903201358w2e13f785n588809ed8f6d0bdc@mail.gmail.com> <1E10954A-136D-4E1E-B576-31D09EE46499@gmail.com> <E1LmFZX-0006RF-Tt@elasmtp-curtail.atl.sa.earthlink.net> <dcc563d10903241616l2c16e803q7f327e4d7aaf5c43@mail.gmail.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