From: Scott Whitney <scott@journyx.com>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: pgsql-admin@postgresql.org, fel <fellsin@hotmail.com>
Subject: Re: [NOVICE] - SAN/NAS/DAS - Need advises
Date: Tue, 7 Sep 2010 10:58:06 -0500 (CDT)
Message-ID: <24583153.39210.1283875086224.JavaMail.root@zimbra.int.journyx.com> (raw)
In-Reply-To: <21677689.39198.1283874930742.JavaMail.root@zimbra.int.journyx.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott@journyx.com, jd@commandprompt.com, fellsin@hotmail.com
Subject: Re: [NOVICE] - SAN/NAS/DAS - Need advises
In-Reply-To: <24583153.39210.1283875086224.JavaMail.root@zimbra.int.journyx.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox