Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id BC0FF1337B7D for ; Wed, 17 Nov 2010 14:57:15 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 82109-03 for ; Wed, 17 Nov 2010 18:57:08 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from EXHUB018-1.exch018.msoutlookonline.net (exhub018-1.exch018.msoutlookonline.net [64.78.17.16]) by mail.postgresql.org (Postfix) with ESMTP id A06E2133616B for ; Wed, 17 Nov 2010 14:57:07 -0400 (AST) Received: from EXVMBX018-1.exch018.msoutlookonline.net ([64.78.17.47]) by EXHUB018-1.exch018.msoutlookonline.net ([64.78.17.16]) with mapi; Wed, 17 Nov 2010 10:57:06 -0800 From: Scott Carey To: Scott Carey CC: Digimer , Eric Comeau , "pgsql-performance@postgresql.org" Date: Wed, 17 Nov 2010 10:58:36 -0800 Subject: Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins Thread-Topic: [PERFORM] How to achieve sustained disk performance of 1.25 GB write for 5 mins Thread-Index: AcuGiTqYMl0aA+gkQnWXQtIoUJJrjg== Message-ID: <509EE238-275F-4FA0-BACD-24F77DA2F7C0@richrelevance.com> References: <4CE3F498.3060004@alteeve.com> <2CE778F3-1147-4AC3-AA33-1911EDDD7AB9@richrelevance.com> In-Reply-To: <2CE778F3-1147-4AC3-AA33-1911EDDD7AB9@richrelevance.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201011/291 X-Sequence-Number: 41315 On Nov 17, 2010, at 10:48 AM, Scott Carey wrote: >>=20 >> Off hand, I would suggest: >>=20 >> 8x http://www.kingston.com/ssd/vplus100.asp (180MB/sec sustained write)= =20 >> stripped (RAID 0, you did say that you don't care about safety). That=20 >> should be 1.44GB/sec write, minus overhead. >=20 > Can get cheaper disks that go ~135MB/sec write and a couple more of them. >=20 Another option, two of these (650MB+ /sec sustained) in raid 0: http://www.= anandtech.com/show/3997/ocz-revodrive-x2-review/3 No external enclosure required, no raid card required (the card is basicall= y 4 ssd's raided together in one package). Just 2 PCIe slots. The cost se= ems to be not too bad, at least for "how much does it cost to go 600MB/sec"= . $1200 will get two of them, for a total of 480GB and 1300MB/sec. Note, these are not data-safe on power failure.