Bruce Momjian <pgman@candle.pha.pa.us> writes:
> John Hansen wrote:
>> On another note, how do you know for sure, that your drive does not lie
>> about fsync?
> I just tried and got 115tps with fsync off vs 100 with fsync on, so
> fsync is certainly doing something.
[ raised eyebrow... ] Something is wrong with that. I'd expect a
*much* higher difference. It's difficult to credit a tps rate higher
than your disk's RPM rating with fsync on, but most modern CPUs can do
a lot better than that with fsync off. If you have a 7200 RPM drive
then I'd believe the 100 figure, but not the other ...
regards, tom lane