From: Mark Kirkwood <markir@paradise.net.nz>
To: Mikael Carneholm <Mikael.Carneholm@WirelessCar.com>
Cc: Alex Hayward <xelah-pgsql@xelah.com>
Cc: Pgsql performance <pgsql-performance@postgresql.org>
Subject: Re: Hardware: HP StorageWorks MSA 1500
Date: Tue, 25 Apr 2006 11:57:34 +1200
Message-ID: <444D65EE.6040605@paradise.net.nz> (raw)
In-Reply-To: <7F10D26ECFA1FB458B89C5B4B0D72C2B3E40AA@sesrv12.wirelesscar.com>
References: <7F10D26ECFA1FB458B89C5B4B0D72C2B3E40AA@sesrv12.wirelesscar.com>
Mikael Carneholm wrote:
>
>> 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.
>
You should be able to get close to 300Mb/s on each SCSI bus - provided
the PCI bus on the motherboard is 64-bit and runs at 133Mhz or better
(64-bit and 66Mhz give you a 524Mb/s limit).
>
>> 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...
>
Yeah, it depends on the intended workload, but at some point most
databases end up IO bound... so you really want to ensure the IO system
is as capable as possible IMHO.
>
> That's probably true, but *knowing* that the max seq scan speed is that
> high gives you some confidence (true or fake) that the hardware will be
> sufficient the next 2 years or so. So, if dual 2GBit FC:s still don't
> deliver more than 200Mb/s, what does?
>
Most modern PCI-X or PCIe RAID cards will do better than 200Mb/s (e.g.
3Ware 9550SX will do ~800Mb/s).
By way of comparison my old PIII with a Promise TX4000 plus 4 IDE drives
will do 215Mb/s...so being throttled to 200Mb/s on modern hardware seems
unwise to me.
Cheers
Mark
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: markir@paradise.net.nz, Mikael.Carneholm@WirelessCar.com, xelah-pgsql@xelah.com
Subject: Re: Hardware: HP StorageWorks MSA 1500
In-Reply-To: <444D65EE.6040605@paradise.net.nz>
* 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