pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alex Hayward <xelah-pgsql@xelah.com>
To: Pgsql performance <pgsql-performance@postgresql.org>
Subject: Re: Hardware: HP StorageWorks MSA 1500
Date: Mon, 24 Apr 2006 15:36:24 +0100 (BST)
Message-ID: <Pine.LNX.4.58.0604241153260.1140@sphinx.mythic-beasts.com> (raw)
In-Reply-To: <444C29ED.2070901@paradise.net.nz>
References: <7F10D26ECFA1FB458B89C5B4B0D72C2B3E4009@sesrv12.wirelesscar.com>
	<444C29ED.2070901@paradise.net.nz>

On Mon, 24 Apr 2006, Mark Kirkwood wrote:

> If I'm reading the original post correctly, the biggest issue is likely
> to be that the 14 disks on each 2Gbit fibre channel will be throttled to
> 200Mb/s by the channel , when in fact you could expect (in RAID 10
> arrangement) to get about 7 * 70 Mb/s = 490 Mb/s.

The two controllers and two FC switches/hubs are intended for redundancy,
rather than performance, so there's only one 2Gbit channel. I don't know
if its possible to use both in parallel to get better performance.

I believe it's possible to join two or more FC ports on the switch
together, but as there's only port going to the controller internally this
presumably wouldn't help.

There are two SCSI U320 buses, with seven bays on each. I don't know what
the overhead of SCSI is, but you're obviously not going to get 490MB/s
for each set of seven even if the FC could do it.

Of course your database may not spend all day doing sequential scans one
at a time over 14 disks, so it doesn't necessarily matter...




view thread (12+ messages)  latest in thread

Message-ID: <Pine.LNX.4.58.0604241153260.1140@sphinx.mythic-beasts.com>
Permalink:  ../Pine.LNX.4.58.0604241153260.1140@sphinx.mythic-beasts.com/
Also on:    postgresql.org/message-id/Pine.LNX.4.58.0604241153260.1140@sphinx.mythic-beasts.com

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: xelah-pgsql@xelah.com
  Subject: Re: Hardware: HP StorageWorks MSA 1500
  In-Reply-To: <Pine.LNX.4.58.0604241153260.1140@sphinx.mythic-beasts.com>
  References: <7F10D26ECFA1FB458B89C5B4B0D72C2B3E4009@sesrv12.wirelesscar.com> <444C29ED.2070901@paradise.net.nz> <Pine.LNX.4.58.0604241153260.1140@sphinx.mythic-beasts.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