public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: [email protected] <[email protected]>
Cc: [email protected]
Subject: Re: can't explain commit performance win7 vs linux : 8000/s vs 419/s
Date: Sat, 25 Jun 2016 14:08:35 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
List-Unsubscribe:  <mailto:[email protected]?body=unsub%20pgsql-performance>

"[email protected]" <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: can't explain commit performance win7 vs linux : 8000/s vs 419/s
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox