Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
>> WinXP fsync = true 20-28 tps
>> WinXP fsync = false 600 tps
>> Linux fsync = true 800 tps
>> Linux fsync = false 980 tps
> Wow, that's terrible on Windows. If there's a solution, it'd be nice to
> backport it...
Actually, the number that's way out of line there is the Linux w/fsync
one. I infer that he's got disk write cache enabled and therefore the
transactions aren't really being synced to disk at all.
Any claimed TPS rate exceeding your disk drive's rotation rate is a
red flag.
regards, tom lane