> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
