> 1. Windows XP
> 2. QUANTUM FIREBALLP LM20.5 (IDE drive)
> 3. Write caching is off in XP device manager
> 4. fsync is ON in Postgres 8
Coming late into the discussion, there is one more note I'd add to this
- if you're on windows and want to be extra secure, also set
wal_sync_method=fsync_writethrough. This will get it through most (I
would say all if I was sure, but I'm not) IDE disks that lie about write
completion.
//Magnus