Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 773C2632712 for ; Sat, 24 Jul 2010 17:21:32 -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 03651-03 for ; Sat, 24 Jul 2010 20:21:24 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.9]) by mail.postgresql.org (Postfix) with ESMTP id 1AFC66326C0 for ; Sat, 24 Jul 2010 17:21:25 -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=mreu0) with ESMTP (Nemesis) id 0LyyIe-1P7gBe3INk-0145KR; Sat, 24 Jul 2010 22:21:23 +0200 Message-ID: <4C4B4B41.7000800@2ndquadrant.com> Date: Sat, 24 Jul 2010 16:21:21 -0400 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: Yeb Havinga CC: pgsql-performance@postgresql.org Subject: Re: Testing Sandforce SSD References: <4C4A9452.9070100@gmail.com> <4C4B1F84.5030306@2ndquadrant.com> In-Reply-To: <4C4B1F84.5030306@2ndquadrant.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V02:K0:u7apSwEUOWrsTPSclc3+JerCr0zLsOF54x11PFA/Ck1 deAcTXHMntZRlSDPFvVf+ViHepAOEmBHC2PnOJQvdqRBleNczH jNRe2eVAvTnxvibGU7rHa9w0P/vkzO4fe+CJMT5kYxIBOaonMu jmjgVUS2Xt/E0b0QOV7oYt1DaigPqwTxEx7KOsL8Du7axTVX3T o0RzeCKoi7F8m1tV9STuITXBK4WTxmQ+RJ7/aQlWsE= 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, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201007/360 X-Sequence-Number: 39749 Greg Smith wrote: > Note that not all of the Sandforce drives include a capacitor; I hope > you got one that does! I wasn't aware any of the SF drives with a > capacitor on them were even shipping yet, all of the ones I'd seen > were the chipset that doesn't include one still. Haven't checked in a > few weeks though. Answer my own question here: the drive Yeb got was the brand spanking new OCZ Vertex 2 Pro, selling for $649 at Newegg for example: http://www.newegg.com/Product/Product.aspx?Item=N82E16820227535 and with the supercacitor listed right in the main production specifications there. This is officially the first inexpensive (relatively) SSD with a battery-backed write cache built into it. If Yeb's test results prove it works as it's supposed to under PostgreSQL, I'll be happy to finally have a moderately priced SSD I can recommend to people for database use. And I fear I'll be out of excuses to avoid buying one as a toy for my home system. -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@2ndQuadrant.com www.2ndQuadrant.us