Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] pgbench Windows outperforms Debian in Write tests while Debian is faster in SELECT only tests - Mailing list pgsql-admin

From Tom Lane
Subject Re: [ADMIN] pgbench Windows outperforms Debian in Write tests while Debian is faster in SELECT only tests
Date
Msg-id 31836.1496045941@sss.pgh.pa.us
Whole thread Raw
In response to [ADMIN] pgbench Windows outperforms Debian in Write tests while Debian is faster in SELECT only tests  ("Klaus P. Pieper" <kpi6288@gmail.com>)
Responses Re: [ADMIN] pgbench Windows outperforms Debian in Write tests while Debian is faster in SELECT only tests  ("Klaus P. Pieper" <kpi6288@gmail.com>)
List pgsql-admin
Tree view 
"Klaus P. Pieper" <kpi6288@gmail.com> writes:
> How can Windows outperform Debian by a factor of 2?

Are you sure you have Windows configured to fsync properly?
Not waiting for writes to hit disk would be a really easy
explanation for a discrepancy of this kind.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Klaus P. Pieper"
Date:
Subject: [ADMIN] pgbench Windows outperforms Debian in Write tests while Debian is faster in SELECT only tests
Next
From: "Klaus P. Pieper"
Date:
Subject: Re: [ADMIN] pgbench Windows outperforms Debian in Write tests while Debian is faster in SELECT only tests