"t.dalpozzo@xxxxxxxxx" <t.dalpozzo@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
