Re: Allowing WAL fsync to be done via O_SYNC
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>, pgsql-hackers@postgresql.org
Date: 2001-03-15T21:32:09Z
Lists: pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes: > I haven't followed the jungle of numbers too closely. > Is it not the case that WAL + fsync is still faster than 7.0 + fsync and > WAL/no fsync is still faster than 7.0/no fsync? I believe the first is true in most cases. I wouldn't swear to the second though, since WAL requires more I/O and doesn't save any fsyncs if you've got 'em all turned off anyway ... regards, tom lane