Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 869C31337BAF for ; Thu, 9 Dec 2010 01:17:53 -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 50776-04-3 for ; Thu, 9 Dec 2010 05:17:45 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-yx0-f174.google.com (mail-yx0-f174.google.com [209.85.213.174]) by mail.postgresql.org (Postfix) with ESMTP id C656E1337BA5 for ; Thu, 9 Dec 2010 01:17:45 -0400 (AST) Received: by yxt3 with SMTP id 3so1148883yxt.19 for ; Wed, 08 Dec 2010 21:17:45 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:from:to:cc:references :in-reply-to:subject:date:message-id:mime-version:content-type :content-transfer-encoding:x-mailer:thread-index:content-language; bh=WRX/HV0CMKCt8tAOnDVzOSaYA0ZWv/Qqm4Gjj8oLQz0=; b=RX+HSPiZhZcNstXhKFz3FboVwKDV/DMruWpMvQEg0XNTeAqHhZhgcVMQZxOZgowdw5 nSl18DvWsj7wZwTVZ1euHIn0UJRuXCyg1+hG6PAOVBWtC0njeQIcOEvmm2hND0yLGct+ wbbgqHHTev2/BPWwIux3KtLXzi5TmxExRLM3E= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=from:to:cc:references:in-reply-to:subject:date:message-id :mime-version:content-type:content-transfer-encoding:x-mailer :thread-index:content-language; b=W+P2i/1+bjcov2OJF3CqtZpjizg227uuZZXXz+FN1Ot3/IcyPKFvhT16LZwxO4oWM3 wpy8S8+6jMIYJ51qDjJCqxvzXMFEiqjayNlJZpZjhtGSxPHujPvLONdPYB74nfvidb4O LPupcifVECu+UqJkySiurmeTivPoQlPC2DWm8= Received: by 10.101.131.18 with SMTP id i18mr6600448ann.27.1291871865446; Wed, 08 Dec 2010 21:17:45 -0800 (PST) Received: from Duality (174-29-78-182.hlrn.qwest.net [174.29.78.182]) by mx.google.com with ESMTPS id x39sm1495121ana.26.2010.12.08.21.17.43 (version=SSLv3 cipher=RC4-MD5); Wed, 08 Dec 2010 21:17:44 -0800 (PST) From: "mark" To: "'Andy'" , "'Marti Raudsepp'" Cc: , "'Benjamin Krajmalnik'" References: <569974.36246.qm@web111307.mail.gq1.yahoo.com> In-Reply-To: <569974.36246.qm@web111307.mail.gq1.yahoo.com> Subject: Re: Hardware recommendations Date: Wed, 8 Dec 2010 22:17:18 -0700 Message-ID: <026901cb9760$5b367020$11a35060$@com> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: AcuXN2QveFWDv9qnQ2mBNLdoupJ9OQAJgmWg Content-Language: en-us X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_LOW=-0.7 X-Spam-Level: X-Archive-Number: 201012/138 X-Sequence-Number: 41590 -----Original Message----- From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Andy Sent: Wednesday, December 08, 2010 5:24 PM To: Marti Raudsepp Cc: pgsql-performance@postgresql.org; Benjamin Krajmalnik Subject: Re: [PERFORM] Hardware recommendations >> > 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. Viking offers 6Gbps SAS physical connector SSD drives as well - with a super capacitor. I have not seen any official pricing yet, but I would suspect it would be in the same ballpark. I am currently begging to get some for eval. I will let everyone know if I swing that and can post numbers. -mark