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 29177.1496088695@sss.pgh.pa.us
Whole thread Raw
In response to 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
"Klaus P. Pieper" <kpi6288@gmail.com> writes:
> However, there may be more people like me just expecting the default
> settings in postgresql.conf being "safe". As far as I understand, they are
> not for the Windows installation. A comment in postgresql.conf might help
> those people.

Yeah, we've just recently realized that they're not safe for Windows
unless you set some system-level options that are not on by default :-(.
I think probably what needs to happen is that we change the default
on Windows.  It's not really my field though, and not much discussion
has happened about it yet.

            regards, tom lane


pgsql-admin by date:

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