From: Michael Stone <mstone+postgres@mathom.us>
To: Tobias Brox <tobias@nordicbet.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: SAN vs Internal Disks
Date: Fri, 07 Sep 2007 09:16:03 -0400
Message-ID: <20070907131601.GG1795@mathom.us> (raw)
In-Reply-To: <20070907103341.GC20896@oppetid.no>
References: <a199704d0709060535q6fea139aq2e3863e685555b0d@mail.gmail.com>
<dcc563d10709060925o6f11f632sbfbc2b64530ae80d@mail.gmail.com>
<a199704d0709061003u71d536fbh9d71ed095dfe16b@mail.gmail.com>
<Pine.GSO.4.64.0709062354040.28915@westnet.com>
<20070907100446.GE1795@mathom.us>
<20070907103341.GC20896@oppetid.no>
On Fri, Sep 07, 2007 at 12:33:41PM +0200, Tobias Brox wrote:
>Advantages:
>
> 1. Higher I/O (at least the salesman claims so)
Benchmark it. It is extremely unlikely that you'll get I/O *as good as*
DAS at a similar price point.
> 2. Easier to upgrade the disk capacity
Is this an issue? You may find that you can simply get dramatically more
space for the money with DAS and not have to worry about an upgrade.
Also, you can use the postgres tablespace functionality to migrate data
to a new partition fairly transparently.
> 3. Easy to set up "warm standby" functionality. (Then again, if the
> postgres server fails miserably, it's likely to be due to a disk
> crash).
You may find that using db replication will gain you even more
reliability for less money.
>Also, my boss states that "all big enterprises uses SAN nowadays".
Use SAN *for what*?
Mike Stone
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-performance@postgresql.org
Cc: mstone+postgres@mathom.us, tobias@nordicbet.com
Subject: Re: SAN vs Internal Disks
In-Reply-To: <20070907131601.GG1795@mathom.us>
* 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