Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 22F596322D5 for ; Sun, 21 Feb 2010 11:01:17 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 67504-05 for ; Sun, 21 Feb 2010 15:00:57 +0000 (UTC) X-Greylist: delayed 00:06:39.491397 by SQLgrey-1.7.6 Received: from smtp113.biz.mail.sp1.yahoo.com (smtp113.biz.mail.sp1.yahoo.com [69.147.92.226]) by mail.postgresql.org (Postfix) with SMTP id 3B09B632E20 for ; Sun, 21 Feb 2010 11:01:06 -0400 (AST) Received: (qmail 92766 invoked from network); 21 Feb 2010 14:54:24 -0000 Received: from [192.168.7.104] (rm_pg@75.37.19.86 with plain) by smtp113.biz.mail.sp1.yahoo.com with SMTP; 21 Feb 2010 06:54:24 -0800 PST X-Yahoo-SMTP: vGlHhPCswBDHoDrPQ1hdAE8TsaGS X-YMail-OSG: Eov7JE0VM1nQx6juqaxnIkzWHeASwuEuJW8V_CH0HHc6Wcw2LXHPqC5lY35sQDPCftA68lSbTB9z0tE7vEs6LSGlahFQPuZbTfVCYhb6QH9NLVdiJ57N9rmc.ovKDccvEycqYY6KMNkXsQhcwuqU_h6UGYs1GP9g3iXGaAQ4HAZTAKHXHHmShxC6_JyDes0BXdkOVp.sqaOvaVbknf1K5JAhY2Em6H.hJvpuSI0NWpWB7gWSDJH1sDWTNFu93ne_NNC.nc5ZkGMZLeWJzGv23D6u4g4ZjTzDWG_8sXgn8_XlYJTVP5.fnKOMJAVfk0fajH35_0k4NJ85jEIqHbUM4lOhjqCbEG6BxIoukw-- X-Yahoo-Newman-Property: ymail-3 Message-ID: <4B814920.1040204@cheapcomplexdevices.com> Date: Sun, 21 Feb 2010 06:54:24 -0800 From: Ron Mayer User-Agent: Thunderbird 2.0.0.23 (X11/20090817) MIME-Version: 1.0 To: Bruce Momjian CC: Ron Mayer , pgsql-performance Subject: Re: SSD + RAID References: <201002211410.o1LEAht05941@momjian.us> In-Reply-To: <201002211410.o1LEAht05941@momjian.us> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201002/290 X-Sequence-Number: 37711 Bruce Momjian wrote: > Agreed, thought I thought the problem was that SSDs lie about their > cache flush like SATA drives do, or is there something I am missing? There's exactly one case I can find[1] where this century's IDE drives lied more than any other drive with a cache: Under 120GB Maxtor drives from late 2003 to early 2004. and it's apparently been worked around for years. Those drives claimed to support the "FLUSH_CACHE_EXT" feature (IDE command 0xEA), but did not support sending 48-bit commands which was needed to send the cache flushing command. And for that case a workaround for Linux was quickly identified by checking for *both* the support for 48-bit commands and support for the flush cache extension[2]. Beyond those 2004 drive + 2003 kernel systems, I think most the rest of such reports have been various misfeatures in some of Linux's filesystems (like EXT3 that only wants to send drives cache-flushing commands when inode change[3]) and linux software raid misfeatures.... ...and ISTM those would affect SSDs the same way they'd affect SATA drives. [1] http://lkml.org/lkml/2004/5/12/132 [2] http://lkml.org/lkml/2004/5/12/200 [3] http://www.mail-archive.com/linux-kernel@vger.kernel.org/msg272253.html