6 SCSI Disks RAID 10 x 2 SCSI DISKS RAID1 + 4 SCSI Disks RAID 10

--_000_7965A9DCF12CC14984420BCC37B1608F25AC1C6A3FElzargrantc ou_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Good afternoon Guys,

I have been reading about RAID for PostgreSQL and some suggestions are:

6 SCSI Disks RAID10 for OS and DB
Or
2 SCSI Disks RAID 1 for OS + 4 SCSI RAID 10 for DB

I know the more spindles you have the better, but if you are going to be re=
ading and writing to the same volume with a single controller, how good tha=
t will be?

How do you guys have your RAIDS setup?

Thank you

Renato





Renato Oliveira
Systems Administrator
e-mail: renato.oliveira [at] grant.co.uk

Tel: +44 (0)1763 260811
Fax: +44 (0)1763 262410
www.grant.co.uk<http://www.grant.co.uk/>

Grant Instruments (Cambridge) Ltd

Company registered in England, registration number 658133

Registered office address:
29 Station Road,
Shepreth,
CAMBS SG8 6GB
UK





P Please consider the environment before printing this email
CONFIDENTIALITY: The information in this e-mail and any attachments is conf=
idential. It is intended only for the named recipients(s). If you are not t=
he named recipient please notify the sender immediately and do not disclose=
the contents to another person or take copies.

VIRUSES: The contents of this e-mail or attachment(s) may contain viruses w=
hich could damage your own computer system. Whilst Grant Instruments (Cambr=
idge) Ltd has taken every reasonable precaution to minimise this risk, we c=
annot accept liability for any damage which you sustain as a result of soft=
ware viruses. You should therefore carry out your own virus checks before o=
pening the attachment(s).

OpenXML: For information about the OpenXML file format in use within Grant =
Instruments please visit our website<http://www.grant.co.uk/Support/openxml=
..html>

--_000_7965A9DCF12CC14984420BCC37B1608F25AC1C6A3FElzargrantc ou_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<HTML xmlns=3D"http://www.w3.org/TR/REC-html40" xmlns:a=3D"urn:schemas-micr=
osoft-com:office:access" xmlns:b=3D"urn:schemas-microsoft-com:office:publis=
her" xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" xml=
ns:D=3D"DAV:" xmlns:dir=3D"http://schemas.microsoft.com/sharepoint/soap/di r=
ectory/" xmlns:ds=3D"http://www.w3.org/2000/09/xmldsig#" xmlns:dsp=3D"http:=
//schemas.microsoft.com/sharepoint/dsp" xmlns:dssi=3D"http://schemas.micros=
oft.com/office/2006/digsig" xmlns:dsss=3D"http://schemas.microsoft.com/offi=
ce/2006/digsig-setup" xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882=
" xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#" xmlns:ex12m=3D"http://sche=
mas.microsoft.com/exchange/services/2006/messages" xmlns:ex12t=3D"http://sc=
hemas.microsoft.com/exchange/services/2006/types" xmlns:html=3D"http://www.=
w3.org/TR/REC-html40" xmlns:m=3D"http://schemas.microsoft.com/office/2004/1=
2/omml" xmlns:mdssi=3D"http://schemas.openxmlformats.org/package/200 6/digit=
al-signature" xmlns:mrels=3D"http://schemas.openxmlformats.org/package/200 6=
/relationships" xmlns:mt=3D"http://schemas.microsoft.com/sharepoint/soap/me=
etings/" xmlns:mver=3D"http://schemas.openxmlformats.org/markup-compa tibili=
ty/2006" xmlns:o=3D"urn:schemas-microsoft-com:office:office" xmlns:oa=3D"ur=
n:schemas-microsoft-com:office:activation" xmlns:odc=3D"urn:schemas-microso=
ft-com:office:odc" xmlns:ois=3D"http://schemas.microsoft.com/sharepoint/soa=
p/ois/" xmlns:p=3D"urn:schemas-microsoft-com:office:powerpoint" xmlns:ppda=
=3D"http://www.passport.com/NameSpace.xsd" xmlns:pptsl=3D"http://schemas.mi=
crosoft.com/sharepoint/soap/SlideLibrary/" xmlns:q=3D"http://schemas.xmlsoa=
p.org/soap/envelope/" xmlns:Repl=3D"http://schemas.microsoft.com/repl/" xml=
ns:rs=3D"urn:schemas-microsoft-com:rowset" xmlns:rtc=3D"http://microsoft.co=
m/officenet/conferencing" xmlns:s=3D"uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14=
882" xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" xmlns:sps=3D"htt=
p://schemas.microsoft.com/sharepoint/soap/" xmlns:spsl=3D"http://microsoft.=
com/webservices/SharePointPortalServer/PublishedLinksService " xmlns:spwp=3D=
"http://microsoft.com/sharepoint/webpartpages" xmlns:ss=3D"urn:schemas-micr=
osoft-com:office:spreadsheet" xmlns:st=3D"" xmlns:sub=3D"http://schemas=
..microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:udc=3D"http://schemas.=
microsoft.com/data/udc" xmlns:udcp2p=3D"http://schemas.microsoft.com/data/u=
dc/parttopart" xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/soap" xm=
lns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile" xmlns:v=3D"urn:=
schemas-microsoft-com:vml" xmlns:w=3D"urn:schemas-microsoft-com:office:word=
" xmlns:wf=3D"http://schemas.microsoft.com/sharepoint/soap/wor kflow/" xmlns=
:x=3D"urn:schemas-microsoft-com:office:excel" xmlns:x2=3D"http://schemas.mi=
crosoft.com/office/excel/2003/xml" xmlns:xsd=3D"http://www.w3.org/2001/XMLS=
chema" xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance" xmlns:Z=3D"u=
rn:schemas-microsoft-com:"><head><META content=3D"text/html; charset=3Dus-a=
scii" http-equiv=3D"Content-Type">
<META content=3D"text/html; charset=3Dus-ascii" http-equiv=3D"Content-Type"=
>

<meta content=3D"text/html; charset=3Dus-ascii" http-equiv=3DContent-Type>
<meta content=3D"Microsoft Word 12 (filtered medium)" name=3DGenerator>
<style>
<!--
/* Font Definitions */
[at] font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
..MsoChpDefault
{mso-style-type:export-only;}
[at] page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head><BODY>
<DIV STYLE=3D"FONT-SIZE: 9pt; FONT-FAMILY: Courier New">
<DIV>
<DIV><FONT FACE=3D"Arial" SIZE=3D"2">

<div class=3DSection1>

<p class=3DMsoNormal>Good afternoon Guys,<o:p></o:p></p>

<p class=3DMsoNormal><o:p> </o:p></p>

<p class=3DMsoNormal>I have been reading about RAID for PostgreSQL and some
suggestions are:<o:p></o:p></p>

<p class=3DMsoNormal><o:p> </o:p></p>

<p class=3DMsoNormal>6 SCSI Disks RAID10 for OS and DB<o:p></o:p></p>

<p class=3DMsoNormal>Or <o:p></o:p></p>

<p class=3DMsoNormal>2 SCSI Disks RAID 1 for OS + 4 SCSI RAID 10 for DB<o:p=
></o:p></p>

<p class=3DMsoNormal><o:p> </o:p></p>

<p class=3DMsoNormal>I know the more spindles you have the better, but if y=
ou are
going to be reading and writing to the same volume with a single controller=
, how
good that will be?<o:p></o:p></p>

<p class=3DMsoNormal><o:p> </o:p></p>

<p class=3DMsoNormal>How do you guys have  your RAIDS setup?<o:p></o:p=
></p>

<p class=3DMsoNormal><o:p> </o:p></p>

<p class=3DMsoNormal>Thank you<o:p></o:p></p>

<p class=3DMsoNormal><o:p> </o:p></p>

<p class=3DMsoNormal>Renato<o:p></o:p></p>

<p class=3DMsoNormal><o:p> </o:p></p>

<p class=3DMsoNormal><o:p> </o:p></p>

<p class=3DMsoNormal><o:p> </o:p></p>

<p class=3DMsoNormal><o:p> </o:p></p>

</div>

</FONT></DIV>
<DIV><FONT FACE=3D"Arial" SIZE=3D"2"></FONT> </DIV>
<DIV><FONT FACE=3D"Arial" SIZE=3D"2"><FONT FACE=3D"Arial" SIZE=3D"2">Renato=
Oliveira<BR>Systems Administrator<BR>e-mail: renato.oliveira [at] grant.co.uk</=
FONT></FONT><FONT FACE=3D"Arial" SIZE=3D"2"><FONT FACE=3D"Arial" SIZE=3D"2"=
></FONT></FONT></DIV>
<DIV><FONT FACE=3D"Arial" SIZE=3D"2"><FONT FACE=3D"Arial" SIZE=3D"2"></FONT=
></FONT> </DIV>
<DIV><FONT FACE=3D"Arial" SIZE=3D"2"><FONT FACE=3D"Arial" SIZE=3D"2">Tel: +=
44 (0)1763 260811<BR>Fax: +44 (0)1763 262410<BR><A HREF=3D"http://www.grant=
..co.uk/">www.grant.co.uk</A></FONT></FONT></DIV>
<DIV><FONT FACE=3D"Arial" SIZE=3D"2"><FONT FACE=3D"Arial" SIZE=3D"2"></FONT=
></FONT> </DIV>
<DIV><FONT FACE=3D"Arial" SIZE=3D"2"><FONT FACE=3D"Arial" SIZE=3D"2">Grant =
Instruments (Cambridge) Ltd <BR> <BR>Company registered in England, re=
gistration number 658133<BR> <BR>Registered office address:<BR>29 Stat=
ion Road, <BR>Shepreth, <BR>CAMBS SG8 6GB <BR>UK</FONT></FONT></DIV>
<DIV><FONT FACE=3D"Arial" SIZE=3D"2"><FONT FACE=3D"Arial" SIZE=3D"2"></FONT=
></FONT><FONT FACE=3D"Arial" SIZE=3D"2"><FONT FACE=3D"Arial" SIZE=3D"2"></F=
ONT></FONT> </DIV>
<DIV><FONT FACE=3D"Arial" SIZE=3D"2"><FONT FACE=3D"Arial" SIZE=3D"2"></FONT=
></FONT></DIV>
<DIV><FONT FACE=3D"Arial" SIZE=3D"2"><FONT FACE=3D"Arial" SIZE=3D"2"></FONT=
></FONT> </DIV>
<DIV><FONT FACE=3D"Arial" SIZE=3D"2"><FONT FACE=3D"Arial" SIZE=3D"2"></FONT=
></FONT></DIV>
<DIV> </DIV>
<DIV><FONT FACE=3D"Arial" SIZE=3D"2"><FONT FACE=3D"Arial" SIZE=3D"2"></FONT=
></FONT></DIV>
<DIV> </DIV> </DIV>
<DIV>
<P CLASS=3D"MsoNormal"><EM><B><SPAN LANG=3D"EN-US" STYLE=3D"FONT-SIZE: 18pt=
; COLOR: green; FONT-FAMILY: Webdings"></SPAN></B></EM> </P>
<P CLASS=3D"MsoNormal"><EM><B><SPAN LANG=3D"EN-US" STYLE=3D"FONT-SIZE: 18pt=
; COLOR: green; FONT-FAMILY: Webdings">P</SPAN></B></EM><EM><B><SPAN LANG=
=3D"EN-US" STYLE=3D"FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Verdana','=
sans-serif'"> </SPAN></B></EM><STRONG><I><SPAN STYLE=3D"FONT-SIZE: 7.5pt; C=
OLOR: green; FONT-FAMILY: 'Arial','sans-serif'">Please consider the environ=
ment before printing this email</SPAN></I></STRONG></P></DIV>
<DIV><FONT FACE=3D"Arial" SIZE=3D"2"><STRONG>CONFIDENTIALITY</STRONG>: The =
information in this e-mail and any attachments is confidential. It is inten=
ded only for the named recipients(s). If you are not the named recipient pl=
ease notify the sender immediately and do not disclose the contents to anot=
her person or take copies. </FONT></DIV>
<DIV><FONT FACE=3D"Arial" SIZE=3D"2"></FONT> </DIV>
<DIV><FONT FACE=3D"Arial" SIZE=3D"2"><STRONG></STRONG></FONT></DIV>
<DIV><FONT FACE=3D"Arial" SIZE=3D"2"><STRONG>VIRUSES:</STRONG> The contents=
of this e-mail or attachment(s) may contain viruses which could damage you=
r own computer system. Whilst Grant Instruments (Cambridge) Ltd has taken e=
very reasonable precaution to minimise this risk, we cannot accept liabilit=
y for any damage which you sustain as a result of software viruses. You sho=
uld therefore carry out your own virus checks before opening the attachment=
(s).</FONT></DIV>
<DIV> </DIV>
<DIV><FONT FACE=3D"Arial" SIZE=3D"2"></FONT></DIV>
<DIV><FONT FACE=3D"Arial" SIZE=3D"2"><STRONG>OpenXML</STRONG>: For informat=
ion about the OpenXML file format in use within Grant Instruments please vi=
sit our <A HREF=3D"http://www.grant.co.uk/Support/openxml.html">website</A>=
</FONT></DIV></DIV></BODY></HTML>

--_000_7965A9DCF12CC14984420BCC37B1608F25AC1C6A3FElzargrantc ou_--
Renato Oliveira [ Do, 06 Mai 2010 15:10 ] [ ID #2040994 ]

Re: 6 SCSI Disks RAID 10 x 2 SCSI DISKS RAID1 + 4 SCSIDisks RAID 10

------=_Part_17433_5387367.1273152946836
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Well, there are quite a few more variables to consider, including:

a) speed of the drives
b) battery backed caching controller or not
c) throughput of the controller channels
d) your particular use

Point d is kind of the most important. We've got about 250 customers talking to the same back-end database server with an IBM ServeRaid card. Our O/S is on a RAID 1 while our pgdata (including logs, in our case) is on an external FC array with 14 drives (12 online, 2 HSP, RAID 10). Our performance is pretty good, though we're a bit CPU bound (not I/O bound at this time) due to an older server system.

What sort of data/usage you're going to have in that database is pretty important. Heavy SELECT databases have different implications than heavy INSERT databases.

So far as the RAID controller goes, so long as it's got 2 or more channels, and the sustained throughput of the card is 100% on each channel, you're fine there.

We _did_ find a significant performance increase splitting our O/S and our PostgreSQL data, but *** in our case, at the time of testing *** we did not see an appreciable difference in splitting the logs off to their own volume.

----- "Renato Oliveira" <renato.oliveira [at] grant.co.uk> wrote:
>
>


>

Good afternoon Guys,



I have been reading about RAID for PostgreSQL and some suggestions are:



6 SCSI Disks RAID10 for OS and DB

Or

2 SCSI Disks RAID 1 for OS + 4 SCSI RAID 10 for DB



I know the more spindles you have the better, but if you are going to be reading and writing to the same volume with a single controller, how good that will be?



How do you guys have your RAIDS setup?



Thank you



Renato









Renato Oliveira
> Systems Administrator
> e-mail: renato.oliveira [at] grant.co.uk

Tel: +44 (0)1763 260811
> Fax: +44 (0)1763 262410
> www.grant.co.uk

Grant Instruments (Cambridge) Ltd
>
> Company registered in England, registration number 658133
>
> Registered office address:
> 29 Station Road,
> Shepreth,
> CAMBS SG8 6GB
> UK











P Please consider the environment before printing this email
CONFIDENTIALITY : The information in this e-mail and any attachments is confidential. It is intended only for the named recipients(s). If you are not the named recipient please notify the sender immediately and do not disclose the contents to another person or take copies.


VIRUSES: The contents of this e-mail or attachment(s) may contain viruses which could damage your own computer system. Whilst Grant Instruments (Cambridge) Ltd has taken every reasonable precaution to minimise this risk, we cannot accept liability for any damage which you sustain as a result of software viruses. You should therefore carry out your own virus checks before opening the attachment(s).


OpenXML : For information about the OpenXML file format in use within Grant Instruments please visit our website
------=_Part_17433_5387367.1273152946836
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><style type=3D'text/css'>p { margin: 0; }</style></head><body><=
div style=3D'font-family: Times New Roman; font-size: 12pt; color: #000000'=
>Well, there are quite a few more variables to consider, including:<br><br>=
a) speed of the drives<br>b) battery backed caching controller or not<br>c)=
throughput of the controller channels<br>d) your particular use<br><br>Poi=
nt d is kind of the most important. We've got about 250 customers talking t=
o the same back-end database server with an IBM ServeRaid card. Our O/S is =
on a RAID 1 while our pgdata (including logs, in our case) is on an externa=
l FC array with 14 drives (12 online, 2 HSP, RAID 10). Our performance is p=
retty good, though we're a bit CPU bound (not I/O bound at this time) due t=
o an older server system.<br><br>What sort of data/usage you're going to ha=
ve in that database is pretty important. Heavy SELECT databases have differ=
ent implications than heavy INSERT databases.<br><br>So far as the RAID con=
troller goes, so long as it's got 2 or more channels, and the sustained thr=
oughput of the card is 100% on each channel, you're fine there.<br><br>We _=
did_ find a significant performance increase splitting our O/S and our Post=
greSQL data, but *** in our case, at the time of testing *** we did not see=
an appreciable difference in splitting the logs off to their own volume. <=
br><br>----- "Renato Oliveira" <renato.oliveira [at] grant.co.uk> wrote:
<br>>




<style>
<!--
/* Font Definitions */
[at] font-face
=09{font-family:Calibri;
=09panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
=09{margin:0cm;
=09margin-bottom:.0001pt;
=09font-size:11.0pt;
=09font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
=09{mso-style-priority:99;
=09color:blue;
=09text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
=09{mso-style-priority:99;
=09color:purple;
=09text-decoration:underline;}
span.EmailStyle17
=09{mso-style-type:personal-compose;
=09font-family:"Calibri","sans-serif";
=09color:windowtext;}
..MsoChpDefault
=09{mso-style-type:export-only;}
[at] page Section1
=09{size:612.0pt 792.0pt;
=09margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
=09{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->

<div style=3D"font-size: 9pt; font-family: Courier New;">>
<div>
<div><font face=3D"Arial" size=3D"2">

<div class=3D"Section1">>

<p class=3D"MsoNormal">Good afternoon Guys,</p>

<p class=3D"MsoNormal"> </p>

<p class=3D"MsoNormal">I have been reading about RAID for PostgreSQL and so=
me
suggestions are:</p>

<p class=3D"MsoNormal"> </p>

<p class=3D"MsoNormal">6 SCSI Disks RAID10 for OS and DB</p>

<p class=3D"MsoNormal">Or </p>

<p class=3D"MsoNormal">2 SCSI Disks RAID 1 for OS + 4 SCSI RAID 10 for DB</=
p>

<p class=3D"MsoNormal"> </p>

<p class=3D"MsoNormal">I know the more spindles you have the better, but if=
you are
going to be reading and writing to the same volume with a single controller=
, how
good that will be?</p>

<p class=3D"MsoNormal"> </p>

<p class=3D"MsoNormal">How do you guys have  your RAIDS setup?</p>

<p class=3D"MsoNormal"> </p>

<p class=3D"MsoNormal">Thank you</p>

<p class=3D"MsoNormal"> </p>

<p class=3D"MsoNormal">Renato</p>

<p class=3D"MsoNormal"> </p>

<p class=3D"MsoNormal"> </p>

<p class=3D"MsoNormal"> </p>

<p class=3D"MsoNormal"> </p>

</div>

</font></div>
<div><font face=3D"Arial" size=3D"2"></font> </div>
<div><font face=3D"Arial" size=3D"2"><font face=3D"Arial" size=3D"2">Renato=
Oliveira<br>> Systems Administrator<br>> e-mail: renato.oliveira [at] gra=
nt.co.uk</font></font><font face=3D"Arial" size=3D"2"><font face=3D"Arial" =
size=3D"2"></font></font></div>
<div><font face=3D"Arial" size=3D"2"><font face=3D"Arial" size=3D"2"></font=
></font> </div>
<div><font face=3D"Arial" size=3D"2"><font face=3D"Arial" size=3D"2">Tel: +=
44 (0)1763 260811<br>> Fax: +44 (0)1763 262410<br>> <a href=3D"http:/=
/www.grant.co.uk/" target=3D"_blank">www.grant.co.uk</a></font></font></div=
>
<div><font face=3D"Arial" size=3D"2"><font face=3D"Arial" size=3D"2"></font=
></font> </div>
<div><font face=3D"Arial" size=3D"2"><font face=3D"Arial" size=3D"2">Grant =
Instruments (Cambridge) Ltd <br>>  <br>> Company registered in E=
ngland, registration number 658133<br>>  <br>> Registered office=
address:<br>> 29 Station Road, <br>> Shepreth, <br>> CAMBS SG8 6G=
B <br>> UK</font></font></div>
<div><font face=3D"Arial" size=3D"2"><font face=3D"Arial" size=3D"2"></font=
></font><font face=3D"Arial" size=3D"2"><font face=3D"Arial" size=3D"2"></f=
ont></font> </div>
<div><font face=3D"Arial" size=3D"2"><font face=3D"Arial" size=3D"2"></font=
></font></div>
<div><font face=3D"Arial" size=3D"2"><font face=3D"Arial" size=3D"2"></font=
></font> </div>
<div><font face=3D"Arial" size=3D"2"><font face=3D"Arial" size=3D"2"></font=
></font></div>
<div> </div>
<div><font face=3D"Arial" size=3D"2"><font face=3D"Arial" size=3D"2"></font=
></font></div>
<div> </div> </div>
<div>
<p class=3D"MsoNormal"><em><b><span style=3D"font-size: 18pt; color: green;=
font-family: Webdings;" lang=3D"EN-US"></span></b></em> </p>
<p class=3D"MsoNormal"><em><b><span style=3D"font-size: 18pt; color: green;=
font-family: Webdings;" lang=3D"EN-US">P</span></b></em><em><b><span style=
=3D"font-size: 10pt; color: black; font-family: 'Verdana','sans-serif';" la=
ng=3D"EN-US"> </span></b></em><strong><i><span style=3D"font-size: 7.5pt; c=
olor: green; font-family: 'Arial','sans-serif';">Please consider the enviro=
nment before printing this email</span></i></strong></p></div>
<div><font face=3D"Arial" size=3D"2"><strong>CONFIDENTIALITY</strong>: The =
information in this e-mail and any attachments is confidential. It is inten=
ded only for the named recipients(s). If you are not the named recipient pl=
ease notify the sender immediately and do not disclose the contents to anot=
her person or take copies. </font></div>
<div><font face=3D"Arial" size=3D"2"></font> </div>
<div><font face=3D"Arial" size=3D"2"><strong></strong></font></div>
<div><font face=3D"Arial" size=3D"2"><strong>VIRUSES:</strong> The contents=
of this e-mail or attachment(s) may contain viruses which could damage you=
r own computer system. Whilst Grant Instruments (Cambridge) Ltd has taken e=
very reasonable precaution to minimise this risk, we cannot accept liabilit=
y for any damage which you sustain as a result of software viruses. You sho=
uld therefore carry out your own virus checks before opening the attachment=
(s).</font></div>
<div> </div>
<div><font face=3D"Arial" size=3D"2"></font></div>
<div><font face=3D"Arial" size=3D"2"><strong>OpenXML</strong>: For informat=
ion about the OpenXML file format in use within Grant Instruments please vi=
sit our <a href=3D"http://www.grant.co.uk/Support/openxml.html" target=3D"_=
blank">website</a></font></div></div></div></body></html>
------=_Part_17433_5387367.1273152946836--
Scott Whitney [ Do, 06 Mai 2010 15:35 ] [ ID #2040996 ]

Re: 6 SCSI Disks RAID 10 x 2 SCSI DISKS RAID1 + 4 SCSIDisks RAID 10

--=-8msXYqjSzAUTxSdPtP/A
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

I think it's better to put all disk in a RAID10. Your max throughput
with 6 disks will be a 50% better that with 4 disks, and operating
system once booted, does not have to read/write but a few times.

I would divide RAID volume in several partitions: at least, operating
system (/), swap and database (/srv/database) and better another for
homes (/homes). Optionally, another one for logfiles (/var/log).

That's my suggestion. Perhaps somebody has another point of view, but I
prefer to rely in RAID controller and not in putting database stuff in
separated disks.

-----Original Message-----
From: Renato Oliveira <renato.oliveira [at] grant.co.uk>
To: pgsql-admin [at] postgresql.org <pgsql-admin [at] postgresql.org>
Subject: [ADMIN] 6 SCSI Disks RAID 10 x 2 SCSI DISKS RAID1 + 4 SCSI
Disks RAID 10
Date: Thu, 6 May 2010 14:10:49 +0100

Good afternoon Guys,



I have been reading about RAID for PostgreSQL and some suggestions are:



6 SCSI Disks RAID10 for OS and DB

Or

2 SCSI Disks RAID 1 for OS + 4 SCSI RAID 10 for DB



I know the more spindles you have the better, but if you are going to be
reading and writing to the same volume with a single controller, how
good that will be?



How do you guys have your RAIDS setup?



Thank you



Renato











Renato Oliveira
Systems Administrator
e-mail: renato.oliveira [at] grant.co.uk

Tel: +44 (0)1763 260811
Fax: +44 (0)1763 262410
www.grant.co.uk

Grant Instruments (Cambridge) Ltd

Company registered in England, registration number 658133

Registered office address:
29 Station Road,
Shepreth,
CAMBS SG8 6GB
UK









P Please consider the environment before printing this email


CONFIDENTIALITY: The information in this e-mail and any attachments is
confidential. It is intended only for the named recipients(s). If you
are not the named recipient please notify the sender immediately and do
not disclose the contents to another person or take copies.


VIRUSES: The contents of this e-mail or attachment(s) may contain
viruses which could damage your own computer system. Whilst Grant
Instruments (Cambridge) Ltd has taken every reasonable precaution to
minimise this risk, we cannot accept liability for any damage which you
sustain as a result of software viruses. You should therefore carry out
your own virus checks before opening the attachment(s).


OpenXML: For information about the OpenXML file format in use within
Grant Instruments please visit our website


--=-8msXYqjSzAUTxSdPtP/A
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.28.3">
</HEAD>
<BODY>
I think it's better to put all disk in a RAID10. Your max throughput with 6 disks will be a 50% better that with 4 disks, and operating system once booted, does not have to read/write but a few times.<BR>
<BR>
I would divide RAID volume in several partitions: at least, operating system (/), swap and database (/srv/database) and better another for homes (/homes). Optionally, another one for logfiles (/var/log).<BR>
<BR>
That's my suggestion.  Perhaps somebody has another point of view, but I prefer to rely in RAID controller and not in putting database stuff in separated disks.<BR>
<BR>
-----Original Message-----<BR>
<B>From</B>: Renato Oliveira <<A HREF="mailto:Renato%20Oliveira%20%3crenato.oliveira [at] grant.co.uk%3e">renato.oliveira [at] grant.co.uk</A>><BR>
<B>To</B>: pgsql-admin [at] postgresql.org <<A HREF="mailto:%22pgsql-admin [at] postgresql.org%22%20%3cpgsql-admin [at] postgresql.org%3e">pgsql-admin [at] postgresql.org</A>><BR>
<B>Subject</B>: [ADMIN] 6 SCSI Disks RAID 10 x 2 SCSI DISKS RAID1 + 4 SCSI Disks RAID 10<BR>
<B>Date</B>: Thu, 6 May 2010 14:10:49 +0100<BR>
<BR>
<FONT SIZE="2">Good afternoon Guys,</FONT><BR>
<BR>
<FONT SIZE="2"> </FONT><BR>
<BR>
<FONT SIZE="2">I have been reading about RAID for PostgreSQL and some suggestions are:</FONT><BR>
<BR>
<FONT SIZE="2"> </FONT><BR>
<BR>
<FONT SIZE="2">6 SCSI Disks RAID10 for OS and DB</FONT><BR>
<BR>
<FONT SIZE="2">Or </FONT><BR>
<BR>
<FONT SIZE="2">2 SCSI Disks RAID 1 for OS + 4 SCSI RAID 10 for DB</FONT><BR>
<BR>
<FONT SIZE="2"> </FONT><BR>
<BR>
<FONT SIZE="2">I know the more spindles you have the better, but if you are going to be reading and writing to the same volume with a single controller, how good that will be?</FONT><BR>
<BR>
<FONT SIZE="2"> </FONT><BR>
<BR>
<FONT SIZE="2">How do you guys have  your RAIDS setup?</FONT><BR>
<BR>
<FONT SIZE="2"> </FONT><BR>
<BR>
<FONT SIZE="2">Thank you</FONT><BR>
<BR>
<FONT SIZE="2"> </FONT><BR>
<BR>
<FONT SIZE="2">Renato</FONT><BR>
<BR>
<FONT SIZE="2"> </FONT><BR>
<BR>
<FONT SIZE="2"> </FONT><BR>
<BR>
<FONT SIZE="2"> </FONT><BR>
<BR>
<FONT SIZE="2"> </FONT><BR>
<BR>
<BR>
 
<FONT SIZE="2">Renato Oliveira</FONT><BR>
<FONT SIZE="2">Systems Administrator</FONT><BR>
<FONT SIZE="2">e-mail: renato.oliveira [at] grant.co.uk</FONT>
 
<FONT SIZE="2">Tel: +44 (0)1763 260811</FONT><BR>
<FONT SIZE="2">Fax: +44 (0)1763 262410</FONT><BR>
<FONT SIZE="2"><A HREF="http://www.grant.co.uk/">www.grant.co.uk</A></FONT>
 
<FONT SIZE="2">Grant Instruments (Cambridge) Ltd </FONT><BR>
<FONT SIZE="2"> </FONT><BR>
<FONT SIZE="2">Company registered in England, registration number 658133</FONT><BR>
<FONT SIZE="2"> </FONT><BR>
<FONT SIZE="2">Registered office address:</FONT><BR>
<FONT SIZE="2">29 Station Road, </FONT><BR>
<FONT SIZE="2">Shepreth, </FONT><BR>
<FONT SIZE="2">CAMBS SG8 6GB </FONT><BR>
<FONT SIZE="2">UK</FONT>
 
<BR>
 
<BR>
 
<BR>
 
 <BR>
<BR>
<B><I><FONT COLOR="#00ff00">P</FONT></I></B><B><I><FONT COLOR="#000000"> </FONT></I></B><B><I><FONT COLOR="#00ff00">Please consider the environment before printing this email</FONT></I></B><BR>
<BR>
<BR>
<B><FONT SIZE="2">CONFIDENTIALITY</FONT></B><FONT SIZE="2">: The information in this e-mail and any attachments is confidential. It is intended only for the named recipients(s). If you are not the named recipient please notify the sender immediately and do not disclose the contents to another person or take copies. </FONT>
 
<BR>
<B><FONT SIZE="2">VIRUSES:</FONT></B><FONT SIZE="2"> The contents of this e-mail or attachment(s) may contain viruses which could damage your own computer system. Whilst Grant Instruments (Cambridge) Ltd has taken every reasonable precaution to minimise this risk, we cannot accept liability for any damage which you sustain as a result of software viruses. You should therefore carry out your own virus checks before opening the attachment(s).</FONT>
 
<BR>
<B><FONT SIZE="2">OpenXML</FONT></B><FONT SIZE="2">: For information about the OpenXML file format in use within Grant Instruments please visit our <A HREF="http://www.grant.co.uk/Support/openxml.html">website</A></FONT>
<BR>
</BODY>
</HTML>

--=-8msXYqjSzAUTxSdPtP/A--
imartinez [ Do, 06 Mai 2010 15:36 ] [ ID #2040997 ]
Datenbanken » gmane.comp.db.postgresql.admin » 6 SCSI Disks RAID 10 x 2 SCSI DISKS RAID1 + 4 SCSI Disks RAID 10

Vorheriges Thema: out of memory ...
Nächstes Thema: PITR backup & Restore issue