Re: can't explain commit performance win7 vs linux : 8000/s vs 419/s

"t(dot)dalpozzo(at)gmail(dot)com" <t(dot)dalpozzo(at)gmail(dot)com> writes:
> Performance:
> Win7: 8000 write/sec
> Linux: 419 write/sec

My immediate reaction to that is that Windows isn't actually writing
the data to disk when it should in order to guarantee that commits
are persistent. There are multiple layers that might be trying to
optimize away the writes, and I don't know enough about Windows to
help you debug it. But see

https://www.postgresql.org/docs/9.5/static/wal-reliability.html

for some discussion.

> I don't figure out why such a difference. Also what should I expect?
> Which one is reasonable?

The lower number sounds a lot more plausible for laptop-grade hardware.
If you weren't using an SSD I wouldn't believe that one was doing
persistent commits either.

regards, tom lane