Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dFR0u-000268-Ai for pgsql-admin@arkaria.postgresql.org; Mon, 29 May 2017 20:11:40 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dFR0t-0000kG-Gb for pgsql-admin@arkaria.postgresql.org; Mon, 29 May 2017 20:11:39 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dFR0s-0000jz-Qv for pgsql-admin@postgresql.org; Mon, 29 May 2017 20:11:38 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dFR0q-0007DP-Fd for pgsql-admin@postgresql.org; Mon, 29 May 2017 20:11:37 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id v4TKBZUT029178; Mon, 29 May 2017 16:11:35 -0400 From: Tom Lane To: "Klaus P. Pieper" cc: pgsql-admin@postgresql.org Subject: Re: pgbench Windows outperforms Debian in Write tests while Debian is faster in SELECT only tests In-reply-to: <007101d2d8b6$b4fc5950$1ef50bf0$@gmail.com> References: <028501d2d84f$2f1ea840$8d5bf8c0$@gmail.com> <20170529181429.4hicimoro6jqog3s@alap3.anarazel.de> <007101d2d8b6$b4fc5950$1ef50bf0$@gmail.com> Comments: In-reply-to "Klaus P. Pieper" message dated "Mon, 29 May 2017 22:03:57 +0200" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <29176.1496088695.1@sss.pgh.pa.us> Date: Mon, 29 May 2017 16:11:35 -0400 Message-ID: <29177.1496088695@sss.pgh.pa.us> X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org "Klaus P. Pieper" 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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin