X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D029E5E48C1 for ; Sun, 5 Sep 2004 19:01:11 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 29412-09 for ; Sun, 5 Sep 2004 18:01:09 +0000 (GMT) Received: from boutiquenumerique.com (gailleton-2-82-67-9-10.fbx.proxad.net [82.67.9.10]) by svr1.postgresql.org (Postfix) with ESMTP id 027955E48BE for ; Sun, 5 Sep 2004 19:01:08 +0100 (BST) Received: (qmail 7774 invoked from network); 5 Sep 2004 20:01:12 +0200 Received: from unknown (HELO musicbox) (192.168.0.2) by gailleton-2-82-67-9-10.fbx.proxad.net with SMTP; 5 Sep 2004 20:01:12 +0200 Date: Sun, 05 Sep 2004 20:01:30 +0200 To: pgsql-performance@postgresql.org Subject: Re: fsync vs open_sync References: <6EE64EF3AB31D5448D0007DD34EEB3412A749A@Herge.rcsinc.local> <41399C55.6050900@bigfoot.com> From: =?iso-8859-15?Q?Pierre-Fr=E9d=E9ric_Caillaud?= Organization: =?iso-8859-15?Q?La_Boutique_Num=E9rique?= Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-ID: In-Reply-To: <41399C55.6050900@bigfoot.com> User-Agent: Opera M2/7.53 (Linux, build 737) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/30 X-Sequence-Number: 8158 Were you upset by my message ? I'll try to clarify. > I understood from your email that you are a Windows haters Well, no, not really. I use Windows everyday and it has its strengths. I still don't think the average (non-geek) person can really use Linux as a Desktop OS. The problem I have with Windows is that I think it could be made much faster, without too much effort (mainly some tweaking in the Disk IO field), but Microsoft doesn't do it. Why ? I can't understand this. >> in Linux. You can write 10000 files in one second and the HDD is still >> idle... then when it decides to flush it all goes to disk in one burst. > > You can not trust your data in this. That's why I mentioned that it did not relate to database type performance. If the computer crashes while writing these files, some may be partially written, some not at all, some okay... the only certainty is about filesystem integrity. But it's exactly the same on all Journaling filesystems (including NTFS). Thus, with equal reliability, the faster wins. Maybe, with Reiser4, we will see real filesystem transactions and maybe this will translate in higher postgres performance... > >> I've had my computers shutdown violently by power failures and no >> reiserfs problems so far. NTFS is very crash proof too. My windows >> machine bluescreens twice a day and still no data loss ;) > > If you have the BSOD twice a day then you have a broken driver or broken > HW. CPU overclocked ? I think this machine has crap hardware. In fact this example was to emphasize the reliability of NTFS : it is indeed remarkable that no data loss occurs even on such a crap machine. I know Windows has got quite reliable now.