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

From: Andres Freund <andres(at)anarazel(dot)de>
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 18:14:29
Message-ID: 20170529181429.4hicimoro6jqog3s@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 2017-05-29 09:42:53 +0200, Klaus P. Pieper wrote:
> Mounting the file system with barriers=0 gives much better results on the
> Debian system (better than the Windows system). But since this machine does
> not have a battery buffered disk adapter, that wouldn't be an option for a
> production system.

> I'm in particular concerned about the disadvantage in the single client
> WRITE scenario running Debian. How can Windows outperform Debian by a factor
> of 2?

Windows IIRC defaults to something close to barriers=0.

- Andres

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Klaus P. Pieper 2017-05-29 19:59:43 Re: pgbench Windows outperforms Debian in Write tests while Debian is faster in SELECT only tests
Previous Message stevenchang1213 2017-05-29 16:57:01 citus extension