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                        |
  [EMAIL PROTECTED]               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to