Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Raid Configurations
- From: Decibel! <decibel(at)decibel(dot)org>
- To: Merlin Moncure <mmoncure(at)gmail(dot)com>
- Cc: "Robert D Oden" <roden(at)dbasetek(dot)com>, "postgresql performance list" <pgsql-performance(at)postgresql(dot)org>
- Subject: Re: Raid Configurations
- Date: Thu, 23 Aug 2007 12:13:43 -0500
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(at)decibel(dot)org EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
- References:
- Raid Configurations
- From: Robert D Oden
- Re: Raid Configurations
- From: Merlin Moncure
- Raid Configurations
- Prev by Date: Re: Optimising "in" queries
- Next by Date: Re: When/if to Reindex
- Previous by thread: Re: Raid Configurations
- Next by thread: Performance Solaris vs Linux
- Indexes: