<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40" xmlns:ns0="urn:schemas-microsoft-com:office:smarttags">
<head>
<!-- Template generated by Exclaimer Mail Disclaimers on 11:54:42 Thursday, 27 October 2011 -->
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">P.30c8d5de-8e29-4aa5-bf2d-3962cc90a7e7 {
MARGIN: 0cm 0cm 0pt
}
LI.30c8d5de-8e29-4aa5-bf2d-3962cc90a7e7 {
MARGIN: 0cm 0cm 0pt
}
DIV.30c8d5de-8e29-4aa5-bf2d-3962cc90a7e7 {
MARGIN: 0cm 0cm 0pt
}
TABLE.30c8d5de-8e29-4aa5-bf2d-3962cc90a7e7Table {
MARGIN: 0cm 0cm 0pt
}
DIV.Section1 {
page: Section1
}
</style>
<meta name="Generator" content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang="EN-US" link="blue" vlink="purple">
<p class="30c8d5de-8e29-4aa5-bf2d-3962cc90a7e7"></p>
<div class="Section1">
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">Question:<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">For large (~1 TB) Postgresql DB is it better to have archive logs on same RAID set as the DB to maximize spindles for the DB or to setup two separate RAID sets
thereby reducing spindles for the DB?<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">We currently have a Dell PowerEdge with PERC (LSI OEM) RAID Controller. Initially it was setup with all 6 internal disks in the same RAID5 set.
<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">Our DBAs believe that having archive logs on same disks as DB is a problem so want us to redo the layout so that we have 1 x 2 disk mirror for the OS and archive
longs and a 1 x 4 disk RAID 5 for the DB. This effectively reduces the spindles for DB from 6 to 4. I’m wondering if the performance implications of such a reduction would outweigh the data integrity setup.<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">Please do NOT suggest installing more disks, or attaching to an external array. These aren’t options for this system. Also please don’t talk about the importance
of doing backups I already know that. Finally don’t talk about whether RAID 5 is a good idea – I already know the pitfalls. My questions is not to talk about how it could be done better with more/different equipment but rather what is best with the equipment
described above.<o:p></o:p></span></font></p>
</div>
<p></p>
<p class="30c8d5de-8e29-4aa5-bf2d-3962cc90a7e7"> </p>
<p class="30c8d5de-8e29-4aa5-bf2d-3962cc90a7e7"> </p>
<p class="30c8d5de-8e29-4aa5-bf2d-3962cc90a7e7"></p>
<p class="30c8d5de-8e29-4aa5-bf2d-3962cc90a7e7"><font face="Arial"><font color="fuchsia"><font style="FONT-FAMILY: Arial; FONT-SIZE: 10pt" size="2"></font></font></font> </p>
<p class="30c8d5de-8e29-4aa5-bf2d-3962cc90a7e7"> </p>
<p class="30c8d5de-8e29-4aa5-bf2d-3962cc90a7e7"><font face="Arial"><font color="fuchsia"><font style="FONT-FAMILY: Arial; FONT-SIZE: 10pt" size="2">Athena<font size="1">®</font>, Created for the Cause</font><font size="1">™
</font></font></font></p>
<p class="30c8d5de-8e29-4aa5-bf2d-3962cc90a7e7"><font size="2" face="Arial">Making a Difference in the Fight Against Breast Cancer</font></p>
<p class="30c8d5de-8e29-4aa5-bf2d-3962cc90a7e7"><span style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></span> </p>
<p class="30c8d5de-8e29-4aa5-bf2d-3962cc90a7e7"><span style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">---------------------------------<br>
CONFIDENTIALITY NOTICE: This e-mail may contain privileged or confidential information and is for the sole use of the intended recipient(s). If you are not the intended recipient, any disclosure, copying, distribution, or use of the contents of this information
is prohibited and may be unlawful. If you have received this electronic transmission in error, please reply immediately to the sender that you have received the message in error, and delete it. Thank you.<br>
----------------------------------</span><span style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt"><o:p></o:p></span></p>
<p> </p>
</body>
</html>