From: Gaetano Mendola <mendola@bigfoot.com>
To: Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
Subject: Re: fsync vs open_sync
Date: Sat, 04 Sep 2004 12:43:33 +0200
Message-ID: <41399C55.6050900@bigfoot.com> (raw)
In-Reply-To: <opsdrj21ogcq72hf@musicbox>
References: <6EE64EF3AB31D5448D0007DD34EEB3412A749A@Herge.rcsinc.local>
<opsdrj21ogcq72hf@musicbox>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mendola@bigfoot.com, lists@boutiquenumerique.com
Subject: Re: fsync vs open_sync
In-Reply-To: <41399C55.6050900@bigfoot.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox