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 20:11:35
Message-ID: 29177.1496088695@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:
> 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Igor Neyman 2017-05-30 14:58:38 Logical Replication in Windows environment
Previous Message Klaus P. Pieper 2017-05-29 20:03:57 Re: pgbench Windows outperforms Debian in Write tests while Debian is faster in SELECT only tests