> -----Original Message----- > From: David F. Skoll [mailto:d...@roaringpenguin.com] > > On Wed, 3 Aug 2011 22:02:53 +0200 > "Giampaolo Tomassoni" <giampa...@tomassoni.biz> wrote: > > > However, since I like to win the last speech, my reply is that they > > hopefully don't necessarily involve an fsync: most modern databases > > use some kind of logging to store and write-back committed > > units-of-work. > > This is OT, but if your database pretends to be "Durable" (the D part > in ACID), it has to flush the write-ahead logs to disk, typically with > an fsync() or fdatasync().
That is meant exactly for this. There would be no need for a log file and a draining thread otherwise. But they are typically outside of the write path of transactions. > > Regards, > > David.