Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 984CF63285F for ; Sun, 21 Feb 2010 10:11:04 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 02166-06 for ; Sun, 21 Feb 2010 14:10:53 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from momjian.us (momjian.us [70.90.9.53]) by mail.postgresql.org (Postfix) with ESMTP id CD322632755 for ; Sun, 21 Feb 2010 10:10:53 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id o1LEAht05941; Sun, 21 Feb 2010 09:10:43 -0500 (EST) From: Bruce Momjian Message-Id: <201002211410.o1LEAht05941@momjian.us> Subject: Re: SSD + RAID In-Reply-To: <6EE5C3AE-2F84-4C8C-AC3E-D76293117352@richrelevance.com> To: Scott Carey Date: Sun, 21 Feb 2010 09:10:43 -0500 (EST) CC: Dan Langille , Matthew Wakeling , Greg Smith , Laszlo Nagy , pgsql-performance X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" 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/289 X-Sequence-Number: 37710 Scott Carey wrote: > On Feb 20, 2010, at 3:19 PM, Bruce Momjian wrote: > > > Dan Langille wrote: > >> -----BEGIN PGP SIGNED MESSAGE----- > >> Hash: SHA1 > >> > >> Bruce Momjian wrote: > >>> Matthew Wakeling wrote: > >>>> On Fri, 13 Nov 2009, Greg Smith wrote: > >>>>> In order for a drive to work reliably for database use such as for > >>>>> PostgreSQL, it cannot have a volatile write cache. You either need a write > >>>>> cache with a battery backup (and a UPS doesn't count), or to turn the cache > >>>>> off. The SSD performance figures you've been looking at are with the drive's > >>>>> write cache turned on, which means they're completely fictitious and > >>>>> exaggerated upwards for your purposes. In the real world, that will result > >>>>> in database corruption after a crash one day. > >>>> Seagate are claiming to be on the ball with this one. > >>>> > >>>> http://www.theregister.co.uk/2009/12/08/seagate_pulsar_ssd/ > >>> > >>> I have updated our documentation to mention that even SSD drives often > >>> have volatile write-back caches. Patch attached and applied. > >> > >> Hmmm. That got me thinking: consider ZFS and HDD with volatile cache. > >> Do the characteristics of ZFS avoid this issue entirely? > > > > No, I don't think so. ZFS only avoids partial page writes. ZFS still > > assumes something sent to the drive is permanent or it would have no way > > to operate. > > > > ZFS is write-back cache aware, and safe provided the drive's > cache flushing and write barrier related commands work. It will > flush data in 'transaction groups' and flush the drive write > caches at the end of those transactions. Since its copy on > write, it can ensure that all the changes in the transaction > group appear on disk, or all are lost. This all works so long > as the cache flush commands do. 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? -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do + If your life is a hard drive, Christ can be your backup. +