Re: Hardware purchase question - Mailing list pgsql-performance

From Joshua D. Drake
Subject Re: Hardware purchase question
Date
Msg-id 41BDD001.8070701@commandprompt.com
Whole thread Raw
In response to Re: Hardware purchase question  (Vivek Khera <khera@kcilink.com>)
Responses Re: Hardware purchase question  (Andrew Hood <ahood.lists@ambergreen.co.uk>)
Re: Hardware purchase question  (Mitch Pirtle <mitch.pirtle@gmail.com>)
List pgsql-performance
> However, I keep getting conflicting advice.  My choices are along
> these lines:
>
> Dual Xeon 64bit with built-in 6-disk RAID10 or RAID5 (LSI RAID card)
> Dual Opteron 64bit with built-in 6-disk RAID10 or RAID5 (LSI RAID card)
> Dual Opteron 64bit with external RAID via fibre channel (eg, nstor)

An Opteron, properly tuned with PostgreSQL will always beat a Xeon
in terms of raw cpu.

RAID 10 will typically always outperform RAID 5 with the same HD config.

Fibre channel in general will always beat a normal (especially an LSI) raid.

Dell's suck for PostgreSQL.

Sincerely,

Joshua D. Drake




>
> I'm sure any of these will whip the bottom off the Dell 2650, but
> which will be the fastest overall?  No way to know without spending
> lots of money to test. :-(
>
> Dell claims their new 2750 will be faster, but they've lost the battle
> already, and won't commit to any performance numbers.  Won't even give
> me a ballpark number.
>


--
Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Attachment

pgsql-performance by date:

Previous
From: Vivek Khera
Date:
Subject: Re: Off-list Re: Alternatives to Dell?
Next
From: Bruce Momjian
Date:
Subject: Re: Alternatives to Dell?