"t.dalpozzo@gmail.com" <t.dalpozzo@gmail.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
