pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joshua D. Drake <jd@commandprompt.com>
To: Christopher Browne <cbbrowne@acm.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: which dual-CPU hardware/OS is fastest for PostgreSQL?
Date: Mon, 10 Jan 2005 20:31:22 -0800
Message-ID: <41E3569A.4030102@commandprompt.com> (raw)
In-Reply-To: <m3mzvgd323.fsf@knuth.knuth.cbbrowne.com>
References: <59b2d39b05011018421680264b@mail.gmail.com>
	<m3mzvgd323.fsf@knuth.knuth.cbbrowne.com>


>
>RAID controllers tend to use i960 or StrongARM CPUs that run at speeds
>that _aren't_ all that impressive.  With software RAID, you can take
>advantage of the _enormous_ increases in the speed of the main CPU.
>
>I don't know so much about FreeBSD's handling of this, but on Linux,
>there's pretty strong indication that _SOFTWARE_ RAID is faster than
>hardware RAID.
>  
>
Unless something has changed though, you can't run raid 10
with linux software raid and raid 5 sucks for heavy writes.

J



>It has the further merit that you're not dependent on some disk
>formatting scheme that is only compatible with the model of RAID
>controller that you've got, where if the controller breaks down, you
>likely have to rebuild the whole array from scratch and your data is
>toast.
>
>The assumptions change if you're looking at really high end disk
>arrays, but that's certainly another story.
>  
>


-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

Attachments:

jd.vcf (text/x-vcard, 283B) download begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;PO Box 215 ;Cascade Locks;OR;97014;US email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 x-mozilla-html:FALSE url:http://www.commandprompt.com version:2.1 end:vcard

view thread (36+ messages)  latest in thread

Message-ID: <41E3569A.4030102@commandprompt.com>
Permalink:  ../41E3569A.4030102@commandprompt.com/
Also on:    postgresql.org/message-id/41E3569A.4030102@commandprompt.com

 · 

reply

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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: jd@commandprompt.com, cbbrowne@acm.org
  Subject: Re: which dual-CPU hardware/OS is fastest for PostgreSQL?
  In-Reply-To: <41E3569A.4030102@commandprompt.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