Re: pgbench Windows outperforms Debian in Write tests while Debian is faster in SELECT only tests

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Klaus P(dot) Pieper" <kpi6288(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pgbench Windows outperforms Debian in Write tests while Debian is faster in SELECT only tests
Date: 2017-05-29 08:19:01
Message-ID: 31836.1496045941@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Klaus P. Pieper" <kpi6288(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Klaus P. Pieper 2017-05-29 12:58:46 Re: pgbench Windows outperforms Debian in Write tests while Debian is faster in SELECT only tests
Previous Message Klaus P. Pieper 2017-05-29 07:42:53 pgbench Windows outperforms Debian in Write tests while Debian is faster in SELECT only tests