From: Tobias Brox <tobias@nordicbet.com>
To: Arjen van der Meijden <acmmailing@tweakers.net>
Cc: Tobias Brox <tobias@nordicbet.com>
Cc: Peter Koczan <pjkoczan@gmail.com>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Anyone using a SAN?
Date: Thu, 14 Feb 2008 00:29:46 +0100
Message-ID: <20080213232946.GP9596@mail.nordicbet.com> (raw)
In-Reply-To: <47B36D49.10105@tweakers.net>
References: <4544e0330802130856t10582294lfa93bc91e234ed01@mail.gmail.com>
<20080213210655.GL9596@mail.nordicbet.com>
<47B36D49.10105@tweakers.net>
[Arjen van der Meijden]
> Your SAN-pusher should have a look at the HP-submissions for TPC-C...
> The recent Xeon systems are all without SAN's and still able to connect
> hundreds of SAS-disks.
Yes, I had a feeling that the various alternative solutions for "direct
connection" hadn't been investigated fully. I was pushing for it, but
hardware is not my thing. Anyway, most likely the only harm done by
chosing SAN is that it's more expensive than an equivalent solution with
direct connected disks. Well, not my money anyway. ;-)
> Obviously its a bit difficult to share those 628 harddrives amongst
> several systems, but the argument your colleagues have for SAN isn't a
> very good one.
As far as I've heard, you cannot really benefit much from this with
postgres, one cannot have two postgres servers on two hosts sharing the
same data (i.e. using one for failover or for CPU/memory-bound read
queries).
Having the SAN connected to several hosts gives us two benefits, if the
database host goes down but not the SAN, it will be quite fast to start
up a new postgres instance on a different host - and it will also be
possible to take out backups real-time from the SAN without much
performance-hit. Anyway, with a warm standby server as described on
http://www.postgresql.org/docs/current/interactive/warm-standby.html one
can achieve pretty much the same without a SAN.
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: tobias@nordicbet.com, acmmailing@tweakers.net, pjkoczan@gmail.com
Subject: Re: Anyone using a SAN?
In-Reply-To: <20080213232946.GP9596@mail.nordicbet.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