Re: Raid Configurations - Mailing list pgsql-performance

From Decibel!
Subject Re: Raid Configurations
Date
Msg-id 35FAAA5F-4130-439A-870F-D83114E75DB9@decibel.org
Whole thread Raw
In response to Re: Raid Configurations  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-performance
On Aug 17, 2007, at 6:55 PM, Merlin Moncure wrote:
> So, I'd be looking at a large raid 10 and 1-2 drives for the WAL...on
> a raid 1.  If your system supports two controllers (in either
> active/active or active/passive), you should look at second controller
> as well.

If you only have one controller, and it can cache writes (it has a
BBU), I'd actually lean towards putting all 12 drives into one raid
10. A good controller will be able to handle WAL fsyncs plenty fast
enough, so having a separate WAL mirror would likely hurt more than
help.
--
Decibel!, aka Jim Nasby                        decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)



pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Optimising "in" queries
Next
From: "Steven Flatt"
Date:
Subject: Re: When/if to Reindex