Date: Tue, 7 Sep 2010 10:58:06 -0500 (CDT)
From: Scott Whitney <scott@journyx.com>
Reply-To: Scott Whitney <swhitney@journyx.com>
To: "Joshua D. Drake" <jd@commandprompt.com>
Cc: pgsql-admin@postgresql.org, fel <fellsin@hotmail.com>
Message-ID: 
 <24583153.39210.1283875086224.JavaMail.root@zimbra.int.journyx.com>
In-Reply-To: 
 <21677689.39198.1283874930742.JavaMail.root@zimbra.int.journyx.com>
Subject: Re: [NOVICE] - SAN/NAS/DAS - Need advises
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_39209_2792507.1283875086221"

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

While I agree with JD, we ended up using a fiber solution through a fiber switch with multi-path drivers (IBM DS4300). It did end up costing a few thousand dollars with all of the drives, but the performance made it worth it. 

The big thing you want to remember to consider with any storage option is the overall I/O of your storage. A single 5400RPM drive with all of your pgdata on it (as well as the logs, let's say) is going to have serious performance implications that you're not going to have with a RAID10 array of 16 drives, for example. 

Personally, having been in IT for _quite_ a few years, I'm still very leery of using network-based storage on database servers specifically. I know other people do it quite successfully out there in the world, but I personally neither want nor need my storage communication going over Ethernet (or such). 


On Tue, 7 Sep 2010 15:03:44 +0200, fel <fellsin@hotmail.com> wrote: 
> Hi all, 
> 
> I am working on upgrading my hardware and wondering how Postgres could 
> work with SAN, NAS and DAS . 
> Can someone advise me or share experiences ? 

Unless you want to spend *A LOT* of money, DAS is the way to go. You can 
get quite a bit of the same functionality without the financial overhead 
from the use of a volume manager + DAS. 

JD 

> 
> Regards, 
> Fel 

-- 
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org 
Consulting, Development, Support, Training 
503-667-4564 - http://www.commandprompt.com/ 
The PostgreSQL Company, serving since 1997 

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) 
To make changes to your subscription: 
http://www.postgresql.org/mailpref/pgsql-admin 


------=_Part_39209_2792507.1283875086221
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'=
>While I agree with JD, we ended up using a fiber solution through a fiber =
switch with multi-path drivers (IBM DS4300). It did end up costing a few th=
ousand dollars with all of the drives, but the performance made it worth it=
.<br><br>The big thing you want to remember to consider with any storage op=
tion is the overall I/O of your storage. A single 5400RPM drive with all of=
 your pgdata on it (as well as the logs, let's say) is going to have seriou=
s performance implications that you're not going to have with a RAID10 arra=
y of 16 drives, for example.<br><br>Personally, having been in IT for _quit=
e_ a few years, I'm still very leery of using network-based storage on data=
base servers specifically. I know other people do it quite successfully out=
 there in the world, but I personally neither want nor need my storage comm=
unication going over Ethernet (or such).<br><br><br><hr><blockquote style=
=3D"border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left=
: 5px;">On Tue, 7 Sep 2010 15:03:44 +0200, fel &lt;fellsin@hotmail.com&gt; =
wrote:<br>&gt; Hi all,<br>&gt; <br>&gt; I am working on upgrading my hardwa=
re and wondering how Postgres could <br>&gt; work with SAN, NAS and DAS .<b=
r>&gt; Can someone advise me or share experiences ?<br><br>Unless you want =
to spend *A LOT* of money, DAS is the way to go. You can<br>get quite a bit=
 of the same functionality without the financial overhead<br>from the use o=
f a volume manager + DAS.<br><br>JD<br><br>&gt; <br>&gt; Regards,<br>&gt; F=
el<br><br>-- <br>PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org=
<br>&nbsp;&nbsp; Consulting, Development, Support, Training<br>&nbsp;&nbsp;=
 503-667-4564 - http://www.commandprompt.com/<br>&nbsp;&nbsp; The PostgreSQ=
L Company, serving since 1997<br><br>-- <br>Sent via pgsql-admin mailing li=
st (pgsql-admin@postgresql.org)<br>To make changes to your subscription:<br=
>http://www.postgresql.org/mailpref/pgsql-admin<br></blockquote><br></div><=
/body></html>
------=_Part_39209_2792507.1283875086221--