Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id C64FF1336B42 for ; Wed, 8 Dec 2010 20:23:49 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 52442-04 for ; Thu, 9 Dec 2010 00:23:42 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm1.bullet.mail.ne1.yahoo.com (nm1.bullet.mail.ne1.yahoo.com [98.138.90.64]) by mail.postgresql.org (Postfix) with SMTP id 7AB0A133655C for ; Wed, 8 Dec 2010 20:23:42 -0400 (AST) Received: from [98.138.90.55] by nm1.bullet.mail.ne1.yahoo.com with NNFMP; 09 Dec 2010 00:23:42 -0000 Received: from [98.138.87.6] by tm8.bullet.mail.ne1.yahoo.com with NNFMP; 09 Dec 2010 00:23:42 -0000 Received: from [127.0.0.1] by omp1006.mail.ne1.yahoo.com with NNFMP; 09 Dec 2010 00:23:42 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 317610.35910.bm@omp1006.mail.ne1.yahoo.com Received: (qmail 36596 invoked by uid 60001); 9 Dec 2010 00:23:41 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1291854221; bh=N/ujOdrQQFEhX1hZpYtVDoEcrZBkJ+Vz6BweBh/Z+Zo=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=L0Sk86Nv9sIVO/syvcSbwupYjKCVxyVCUyLVo2sNzEDn1KdKtijSuOoVuqNFG5+E4PJt7ud0hqONMdj24CgJBe6bL2NKKhCAagOug51TpbzVZPLz0fftMyn7oF7vEpGMbU6+yYqVZcQh+N/vY8MUaVyc9tVrf7wBq7CsClaGUtg= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=pBs15tD0D/TXdh9fa3BcGvPHLnyIREvB5q4QunEz6PRx+JRVAiaNOOPjIVsK1vs8QTZAiLqtvwDH5j7kbk0bB5ql4syLjQUxmWW+eJznKCs8emdx6JSwqJl8BqAHC+v7Ah2lSUpMOYvHW7Wrt95AuV5nAT82FSCYT4qEEokk5oM=; Message-ID: <569974.36246.qm@web111307.mail.gq1.yahoo.com> X-YMail-OSG: 80kxodIVM1nylpH1L.BUAR.bWA1yjuTvpnEQA6C81tBy9aI xi98y2iuzxD4r6iHRdKDewy5nmW6pcro_Pemc.QxZnKYSYRYvpBomPk9xUVK mceFWm.BVeJ61G57LXshuc.eVFvu1ZNtyzwxLZTCG0UozzS51GP82rzY.MgH F8qZww2Ym09BBzTiinwoOTrl1t3xQw1CArGwXZJVhqmLp_V3hrpU1GZCTBNo 1Nx2UAT_TvmBIR9efP2X0YK4Ki7ceWn.BXHhVpBxPXZa8D94b2iNu_oc4m7F fv6TDCb_SEF0KtiUkLhFGxlUTYCGte1jPckPVlMDYh_c5LqUq1DhsacxgC28 Vm.sw Received: from [24.34.116.197] by web111307.mail.gq1.yahoo.com via HTTP; Wed, 08 Dec 2010 16:23:41 PST X-Mailer: YahooMailClassic/11.4.20 YahooMailWebService/0.8.107.285259 Date: Wed, 8 Dec 2010 16:23:41 -0800 (PST) From: Andy Subject: Re: Hardware recommendations To: Marti Raudsepp Cc: pgsql-performance@postgresql.org, Benjamin Krajmalnik In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.792 tagged_above=-10 required=5 tests=BAYES_50=0.8, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201012/126 X-Sequence-Number: 41578 > > If you are IO-bound, you might want to consider using > SSD. > > > > A single SSD could easily give you more IOPS than 16 > 15k SAS in RAID 10. > > Are there any that don't risk your data on power loss, AND > are cheaper > than SAS RAID 10? > Vertex 2 Pro has a built-in supercapacitor to save data on power loss. It's spec'd at 50K IOPS and a 200GB one costs around $1,000.