Re: Proposed LogWriter Scheme, WAS: Potential Large Performance Gain in WAL synching
Doug McNaught <doug@wireboard.com>
From: Doug McNaught <doug@wireboard.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "Curtis Faith" <curtis@galtair.com>, "Pgsql-Hackers" <pgsql-hackers@postgresql.org>
Date: 2002-10-05T15:28:07Z
Lists: pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes: > "Curtis Faith" <curtis@galtair.com> writes: > > The log file would be opened O_DSYNC, O_APPEND every time. > > Keep in mind that we support platforms without O_DSYNC. I am not > sure whether there are any that don't have O_SYNC either, but I am > fairly sure that we measured O_SYNC to be slower than fsync()s on > some platforms. And don't we preallocate WAL files anyway? So O_APPEND would be irrelevant? -Doug