Re: [NOVICE] - SAN/NAS/DAS - Need advises

From: Enrico Weigelt <weigelt(at)metux(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: [NOVICE] - SAN/NAS/DAS - Need advises
Date: 2010-09-08 20:13:05
Message-ID: 20100908201305.GA31637@nibiru.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

* Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:

> What really matters here is if the 8gb SAN is as fast as or faster
> than the DAS setup. For most people measuring the speed of the
> interface is a lot like the famous Tom Lane quote about benchmarking
> jet fighters versus airliners by measuring the amount of runway they
> need.

If you really want to know what's better, you'll have to test the
candidates with real loads: record your real runtime load w/ blktrace
and replay them on the candidates.

Nominal performance parameters as insufficient as a dd or iobench test.

For example, take an IBM XIV or DS8k w/ thin provisioning: simply
writing zeros (or just the same pattern to all blocks) will give you
almost the raw bus speed (maybe adding a little bit overhead inside
the storage system), since spindles will idle. Caches (bein RAM or
SSD) can make the storage look way faster than it really is (in rare
cases, bad cache decisions could make also make it slower).

Synthetic tests don't allow you to predict how spindle seeks, bus
jams, etc will behave in real production. It *heavily* depends on
your workload which storage type (and concrete product) will perform
in production, nominal parameters are too vague for enterprise usage.
(no, you can't even tell that DAS is faster than SAN).

You need to test your workload and then decide which product to use.

cu
--
----------------------------------------------------------------------
Enrico Weigelt, metux IT service -- http://www.metux.de/

phone: +49 36207 519931 email: weigelt(at)metux(dot)de
mobile: +49 151 27565287 icq: 210169427 skype: nekrad666
----------------------------------------------------------------------
Embedded-Linux / Portierung / Opensource-QM / Verteilte Systeme
----------------------------------------------------------------------

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Enrico Weigelt 2010-09-08 20:15:12 Re: [NOVICE] - SAN/NAS/DAS - Need advises
Previous Message Bèrto ëd Sèra 2010-09-08 13:10:39 Re: vacuumdb for schema only