Re: Multiple disks: RAID 5 or PG Cluster

From: Vivek Khera <vivek(at)khera(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Multiple disks: RAID 5 or PG Cluster
Date: 2005-06-17 20:21:51
Message-ID: 271D9FF6-9726-4D69-8C45-98B187EE0B82@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message mudfoot 2005-06-17 20:38:41 Re: Multiple disks: RAID 5 or PG Cluster
Previous Message Yves Vindevogel 2005-06-17 19:34:19 Multiple disks: RAID 5 or PG Cluster