Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 571EF63284C for ; Sat, 24 Jul 2010 18:09:49 -0300 (ADT) 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 54566-09 for ; Sat, 24 Jul 2010 21:09:40 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from spinlock.commandprompt.com (host-215.commandprompt.net [207.173.203.215]) by mail.postgresql.org (Postfix) with ESMTP id E3F316324C6 for ; Sat, 24 Jul 2010 18:09:41 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by spinlock.commandprompt.com (Postfix) with ESMTP id 38EDD348034; Sat, 24 Jul 2010 14:09:35 -0700 (PDT) X-Virus-Scanned: Debian amavisd-new at commandprompt.com Received: from spinlock.commandprompt.com ([127.0.0.1]) by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id u-yFOt1ZUymp; Sat, 24 Jul 2010 14:09:32 -0700 (PDT) Received: from [75.142.153.107] (unknown [75.142.153.107]) by spinlock.commandprompt.com (Postfix) with ESMTPSA id 8030E348002; Sat, 24 Jul 2010 14:09:32 -0700 (PDT) Subject: Re: Testing Sandforce SSD From: "Joshua D. Drake" Reply-To: jd@commandprompt.com To: Greg Smith Cc: Yeb Havinga , pgsql-performance@postgresql.org In-Reply-To: <4C4B4B41.7000800@2ndquadrant.com> References: <4C4A9452.9070100@gmail.com> <4C4B1F84.5030306@2ndquadrant.com> <4C4B4B41.7000800@2ndquadrant.com> Content-Type: text/plain; charset="UTF-8" Organization: Command Prompt, Inc. Date: Sat, 24 Jul 2010 14:09:29 -0700 Message-ID: <1280005769.9866.69.camel@jd-desktop.unknown.charter.com> Mime-Version: 1.0 X-Mailer: Evolution 2.28.3 Content-Transfer-Encoding: 7bit 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: 201007/361 X-Sequence-Number: 39750 On Sat, 2010-07-24 at 16:21 -0400, Greg Smith wrote: > 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. 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 Sincerely, Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt