Re: Multiple disks: RAID 5 or PG Cluster - Mailing list pgsql-performance

From Vivek Khera
Subject Re: Multiple disks: RAID 5 or PG Cluster
Date
Msg-id 271D9FF6-9726-4D69-8C45-98B187EE0B82@khera.org
Whole thread Raw
In response to Multiple disks: RAID 5 or PG Cluster  (Yves Vindevogel <yves.vindevogel@implements.be>)
List pgsql-performance

On Jun 17, 2005, at 3:34 PM, Yves Vindevogel wrote:

We are looking to build a new machine for a big PG database.

We were wondering if a machine with 5 scsi-disks would perform better if we use a hardware raid 5 controller or if we would go for the clustering in PG.

If we cluster in PG, do we have redundancy on the data like in a RAID 5 ?


I'd recommend 4 disks in a hardware RAID10 plus a hot spare, or use the 5th disk as boot + OS if you're feeling lucky.


Vivek Khera, Ph.D.

+1-301-869-4449 x806



pgsql-performance by date:

Previous
From: Yves Vindevogel
Date:
Subject: Multiple disks: RAID 5 or PG Cluster
Next
From: mudfoot@rawbw.com
Date:
Subject: Re: Multiple disks: RAID 5 or PG Cluster