X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 9D28411F7DF1 for ; Sun, 23 Apr 2006 23:01:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 48259-01 for ; Sun, 23 Apr 2006 23:01:19 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from linda-4.paradise.net.nz (bm-4a.paradise.net.nz [203.96.152.183]) by postgresql.org (Postfix) with ESMTP id 731A611F660E for ; Sun, 23 Apr 2006 22:29:28 -0300 (ADT) Received: from smtp-1.paradise.net.nz (tclsnelb1-src-1.paradise.net.nz [203.96.152.172]) by linda-4.paradise.net.nz (Paradise.net.nz) with ESMTP id <0IY700D4NDH4LC@linda-4.paradise.net.nz> for pgsql-performance@postgresql.org; Mon, 24 Apr 2006 13:29:28 +1200 (NZST) Received: from [192.168.1.11] (218-101-29-108.dsl.clear.net.nz [218.101.29.108]) by smtp-1.paradise.net.nz (Postfix) with ESMTP id EF8BD582694; Mon, 24 Apr 2006 13:29:27 +1200 (NZST) Date: Mon, 24 Apr 2006 13:29:17 +1200 From: Mark Kirkwood Subject: Re: Hardware: HP StorageWorks MSA 1500 In-reply-to: <7F10D26ECFA1FB458B89C5B4B0D72C2B3E4009@sesrv12.wirelesscar.com> To: Mikael Carneholm Cc: Alex Hayward , Pgsql performance Message-id: <444C29ED.2070901@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7bit User-Agent: Thunderbird 1.5 (X11/20060417) References: <7F10D26ECFA1FB458B89C5B4B0D72C2B3E4009@sesrv12.wirelesscar.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/517 X-Sequence-Number: 18601 Mikael Carneholm wrote: > Your numbers seem quite ok considering the number of disks. We also get > a 256Mb battery backed cache module with it, so I'm looking forward to > testing the write performance (first using ext3, then xfs). If I get the > enough time to test it, I'll test both raid 0+1 and raid 5 > configurations although I trust raid 0+1 more. > > And no, it's not the cheapest way to get storage - but it's only half as > expensive as the other option: an EVA4000, which we're gonna have to go > for if we(they) decide to stay in bed with a proprietary database. With > postgres we don't need replication on SAN level (using slony) so the MSA > 1500 would be sufficient, and that's a good thing (price wise) as we're > gonna need two. OTOH, the EVA4000 will not give us mirroring so either > way, we're gonna need two of whatever system we go for. Just hoping the > MSA 1500 is reliable as well... > > Support will hopefully not be a problem for us as we have a local > company providing support, they're also the ones setting it up for us so > at least we'll know right away if they're compentent or not :) > 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. Cheers Mark