On Wed, 3 Aug 2011 22:47:41 +0200 "Giampaolo Tomassoni" <giampa...@tomassoni.biz> wrote:
> > 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. No, that is incorrect. When you run COMMIT, the database has to flush updates to the log and sync the log files. Regards, David.
