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 96C6A5E4E37 for ; Sat, 4 Sep 2004 14:07:26 +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 24499-03 for ; Sat, 4 Sep 2004 13:06:25 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 48E2B5E4A79 for ; Sat, 4 Sep 2004 14:05:58 +0100 (BST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i84D3fLu025475 for ; Sat, 4 Sep 2004 13:05:27 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i84CbDVV022209 for pgsql-performance@postgresql.org; Sat, 4 Sep 2004 12:37:13 GMT From: Gaetano Mendola X-Newsgroups: comp.databases.postgresql.performance Subject: Re: fsync vs open_sync Date: Sat, 04 Sep 2004 12:43:33 +0200 Organization: PYRENET Midi-pyrenees Provider Lines: 32 Message-ID: <41399C55.6050900@bigfoot.com> References: <6EE64EF3AB31D5448D0007DD34EEB3412A749A@Herge.rcsinc.local> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 8bit X-Complaints-To: abuse@pyrenet.fr To: =?ISO-8859-15?Q?Pierre-Fr=E9d=E9ric_Caillaud?= User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en In-Reply-To: X-Enigmail-Version: 0.85.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=NO_DNS_FOR_FROM X-Spam-Level: * X-Archive-Number: 200409/23 X-Sequence-Number: 8151 Pierre-Frédéric Caillaud wrote: > 22 KB files, 1000 of them : > open(), read(), close() : 10.000 files/s > open(), write(), close() : 4.000 files/s > > This is quite far from database FS activity, but it's still > amazing, although the disk doesn't even get used. Which is what I like > 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. > 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 understood from your email that you are a Windows haters, try to post something here: http://ihatelinux.blogspot.com/ :-) Regards Gaetano Mendola