pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (20+ messages)  latest in thread

Message-ID: <41399C55.6050900@bigfoot.com>
Permalink:  ../41399C55.6050900@bigfoot.com/
Also on:    postgresql.org/message-id/41399C55.6050900@bigfoot.com

 · 

reply

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