Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 4A6C9632202 for ; Sun, 28 Feb 2010 00:05:29 -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 89978-08 for ; Sun, 28 Feb 2010 04:05:18 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp112.biz.mail.sp1.yahoo.com (smtp112.biz.mail.sp1.yahoo.com [69.147.92.225]) by mail.postgresql.org (Postfix) with SMTP id 6EDD0632178 for ; Sun, 28 Feb 2010 00:05:18 -0400 (AST) Received: (qmail 19300 invoked from network); 28 Feb 2010 04:05:17 -0000 Received: from [192.168.7.104] (rm_pg@76.201.141.5 with plain) by smtp112.biz.mail.sp1.yahoo.com with SMTP; 27 Feb 2010 20:05:17 -0800 PST X-Yahoo-SMTP: vGlHhPCswBDHoDrPQ1hdAE8TsaGS X-YMail-OSG: tvW1zTAVM1nfnNPJr7hk.6DjX6bY1lpIYC2jpfMrbJI1d5yNlXuBqvESDF1TNYm3Q7idZAyRQ_dnryKB.3f7bLKq5UyyMoYBMYFY.ps6TVpsrzmxOR2NHFMsY5z035rAcWumfm76iKV8_9dZJ6uW62wRrIpuTE7jSg0rdPZec_Zrmez1bPa5mHKpxYsyy_8UGK.qzQS9T_pPFhdDRjBtkyx5AC34OiJkX.KBIcW4gyzvCEudOvWjt5w6bIX5MntnzS2MBGwkLSuWGAkfx7FwZOWo4ShX8L.kKOutD8stec9mjA_e5yJytkYRylc4i.iun.d44R5YKOI09ur1fWlG X-Yahoo-Newman-Property: ymail-3 Message-ID: <4B89EB7C.8040606@cheapcomplexdevices.com> Date: Sat, 27 Feb 2010 20:05:16 -0800 From: Ron Mayer User-Agent: Thunderbird 2.0.0.23 (X11/20090817) MIME-Version: 1.0 To: Bruce Momjian CC: Greg Smith , Ron Mayer , pgsql-performance Subject: Re: SSD + RAID References: <201002272016.o1RKGXp26284@momjian.us> In-Reply-To: <201002272016.o1RKGXp26284@momjian.us> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=AWL=0.000, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201002/396 X-Sequence-Number: 37817 Bruce Momjian wrote: > Greg Smith wrote: >> Bruce Momjian wrote: >>> I have added documentation about the ATAPI drive flush command, and the >> >> If one of us goes back into that section one day to edit again it might >> be worth mentioning that FLUSH CACHE EXT is the actual ATAPI-6 command >> that a drive needs to support properly. I wouldn't bother with another >> doc edit commit just for that specific part though, pretty obscure. > > That setting name was not easy to find so I added it to the > documentation. If we're spelling out specific IDE commands, it might be worth noting that the corresponding SCSI command is "SYNCHRONIZE CACHE"[1]. Linux apparently sends FLUSH_CACHE commands to IDE drives in the exact sample places it sends SYNCHRONIZE CACHE commands to SCSI drives[2]. It seems that the same file systems, SW raid layers, virtualization platforms, and kernels that have a problem sending FLUSH CACHE commands to SATA drives have he same exact same problems sending SYNCHRONIZE CACHE commands to SCSI drives. With the exact same effect of not getting writes all the way through disk caches. No? [1] http://linux.die.net/man/8/sg_sync [2] http://hardware.slashdot.org/comments.pl?sid=149349&cid=12519114