Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 2867F638117 for ; Sat, 24 Jul 2010 18:16:39 -0300 (ADT) 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 21253-06 for ; Sat, 24 Jul 2010 21:16:30 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.186]) by mail.postgresql.org (Postfix) with ESMTP id 9D900635566 for ; Sat, 24 Jul 2010 18:15:01 -0300 (ADT) Received: from [192.168.1.5] (static-71-179-240-8.bltmmd.fios.verizon.net [71.179.240.8]) by mrelayeu.kundenserver.de (node=mreu2) with ESMTP (Nemesis) id 0Lfneo-1PMa8g1ZDG-00of4V; Sat, 24 Jul 2010 23:14:56 +0200 Message-ID: <4C4B57CF.1040800@2ndquadrant.com> Date: Sat, 24 Jul 2010 17:14:55 -0400 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: jd@commandprompt.com CC: Yeb Havinga , pgsql-performance@postgresql.org Subject: Re: Testing Sandforce SSD References: <4C4A9452.9070100@gmail.com> <4C4B1F84.5030306@2ndquadrant.com> <4C4B4B41.7000800@2ndquadrant.com> <1280005769.9866.69.camel@jd-desktop.unknown.charter.com> In-Reply-To: <1280005769.9866.69.camel@jd-desktop.unknown.charter.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V02:K0:ufGnYqcQ83rgKEAlnnBNvWDTdQIn5AGZngK/eEnmKKM HTyywkJb6M7blwe98Ek7hdVMCEX8GbW2XaWPrZgDB4hM/Ss+PI mFf1xnH8cS8ZkD63Zrr2fklDDpoYrt9IsV3jCsh5LHZbN5835B 2ap9i5nDE1RTOF/bI4BfAswQnfUcahp9AGRqSfuJdi9b1I0o0u smcI5PZBwKDu7zXCrAqFc0o5BdGphbAA0wW4Kx299U= X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.5 tagged_above=-10 required=5 tests=BAYES_05=-0.5, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201007/362 X-Sequence-Number: 39751 Joshua D. Drake wrote: > That is quite the toy. I can get 4 SATA-II with RAID Controller, with > battery backed cache, for the same price or less :P > True, but if you look at tests like http://www.anandtech.com/show/2899/12 it suggests there's probably at least a 6:1 performance speedup for workloads with a lot of random I/O to them. And I'm really getting sick of the power/noise/heat that the 6 drives in my home server produces. -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@2ndQuadrant.com www.2ndQuadrant.us