Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 10D78632A29 for ; Thu, 25 Mar 2010 17:14:35 -0300 (ADT) 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 71542-09 for ; Thu, 25 Mar 2010 20:14:24 +0000 (UTC) X-Greylist: delayed 00:09:26.428791 by SQLgrey-1.7.6 Received: from relay.pcl-ipout02.plus.net (relay.pcl-ipout02.plus.net [212.159.7.100]) by mail.postgresql.org (Postfix) with ESMTP id 7BC2C632942 for ; Thu, 25 Mar 2010 17:14:24 -0300 (ADT) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: Av0EAI9eq0vUnw4U/2dsb2JhbACDF5gRc642kFmBK4JoagQ Received: from pih-relay08.plus.net ([212.159.14.20]) by relay.pcl-ipout02.plus.net with ESMTP; 25 Mar 2010 20:04:56 +0000 Received: from [80.229.150.39] (helo=pd600.barnhouse) by pih-relay08.plus.net with esmtp (Exim) id 1NutIV-0002J3-SE; Thu, 25 Mar 2010 20:04:55 +0000 Received: from [192.168.0.132] (unknown [192.168.0.132]) by pd600.barnhouse (Postfix) with ESMTP id D2DB93A2731; Thu, 25 Mar 2010 20:05:38 +0000 (GMT) Message-ID: <4BABC1E0.7010607@mansionfamily.plus.com> Date: Thu, 25 Mar 2010 20:04:48 +0000 From: James Mansion User-Agent: Thunderbird 2.0.0.24 (Windows/20100228) MIME-Version: 1.0 To: Hannu Krosing CC: Yeb Havinga , Greg Smith , Tom Lane , "Ross J. Reedstrom" , pgsql-performance@postgresql.org Subject: Re: mysql to postgresql, performance questions References: <4BA23936.2030507@gmail.com> <4BA596D2.4050406@squeakycode.net> <20100323185232.GD6662@rice.edu> <5342.1269372121@sss.pgh.pa.us> <4BA934B9.9070401@2ndquadrant.com> <4BA9D39B.6020103@gmail.com> <1269421198.11473.50.camel@hvost> In-Reply-To: <1269421198.11473.50.camel@hvost> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Plusnet-Relay: bc3528f20289357544cf92b2691b6600 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.001 tagged_above=-10 required=5 tests=BAYES_50=0.001, SARE_OEM_OBFU=1 X-Spam-Level: * X-Archive-Number: 201003/324 X-Sequence-Number: 38149 Hannu Krosing wrote: > Pulling the plug should not corrupt a postgreSQL database, unless it was > using disks which lie about write caching. > Didn't we recently put the old wife's 'the disks lied' tale to bed in favour of actually admiting that some well known filesystems and saftware raid systems have had trouble with their write barriers?