Re: further testing on IDE drives

Josh Berkus wrote:
> Bruce,
>
> > Yes.  If you were doing multiple WAL writes before transaction fsync,
> > you would be fsyncing every write, rather than doing two writes and
> > fsync'ing them both.  I wonder if larger transactions would find
> > open_sync slower?
>
> Want me to test?   I've got an ide-based test machine here, and the TPCC
> databases.

I would be interested to see if wal_sync_method = fsync is slower than
wal_sync_method = open_sync.  How often are we doing more then one write
before a fsync anyway?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073