best arrangement of 3 disks for (insert) performance - Mailing list pgsql-performance

From Richard Jones
Subject best arrangement of 3 disks for (insert) performance
Date
Msg-id 200309121126.29756.rj@last.fm
Whole thread Raw
Responses Re: best arrangement of 3 disks for (insert) performance  ("Matt Clark" <matt@ymogen.net>)
Re: best arrangement of 3 disks for (insert) performance  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
Hi all,
I have some new hardware on the way and would like some advice on how to get
the most out of it..

its a dual xeon 2.4,  4gb ram and 3x identical 15k rpm scsi disks

should i mirror 2 of the disks for postgres data, and use the 3rd disk for the
o/s and the pg logs or raid5 the 3 disks or even stripe 2 disks for pg and
use the 3rd for o/s,logs,backups ?

the machine will be dealing with lots of inserts, basically as many as we can
throw at it

thanks,
Richard

pgsql-performance by date:

Previous
From: aturner@neteconomist.com
Date:
Subject: Re: Upgrade Woes
Next
From: "Matt Clark"
Date:
Subject: Re: best arrangement of 3 disks for (insert) performance