Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dFQtt-00014T-8v for pgsql-admin@arkaria.postgresql.org; Mon, 29 May 2017 20:04:25 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dFQts-0004Q2-Rv for pgsql-admin@arkaria.postgresql.org; Mon, 29 May 2017 20:04:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dFQts-0004PG-0l for pgsql-admin@postgresql.org; Mon, 29 May 2017 20:04:24 +0000 Received: from mail-wm0-x234.google.com ([2a00:1450:400c:c09::234]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dFQto-0005nN-KF for pgsql-admin@postgresql.org; Mon, 29 May 2017 20:04:23 +0000 Received: by mail-wm0-x234.google.com with SMTP id b84so67267520wmh.0 for ; Mon, 29 May 2017 13:04:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:references:in-reply-to:subject:date:message-id:mime-version :content-transfer-encoding:content-language:thread-index; bh=ERZzffOQ+R5jbKkYDRfSoInRBSnQYLW4v325QV+6NLs=; b=VgENuYq6Dn2pYw8O/KgCuEC66hDoqegkmxOxEq8hdjmIP+wH/hJgSIzy0SNgy/7Jhy zvSAZFDTxGM/7WRxEMByDKuv7Kw/knctsDkuLN+xa51ddO0mCfKQ6KyYL/u0/KYZPkdm bi1hKi9/SBGC6111gqzTkG2uYygGnwndwBDbfkHAHwyUYRvqrnEtBMHkBNfz49YCGZLM f1oL/EHNGUy6RnZwSDakNX/XrldDN9hdFwQLvYJSHSS2Q5fNBnbyublDYbLMhsdEI/RI OdZJ5QpY+i+mIWhzBz0JmkmLsNqMgm1R5t9bpkmgpTPgbcD4i9eVCkTEs+RS7hEaQjC2 wu/Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:references:in-reply-to:subject:date :message-id:mime-version:content-transfer-encoding:content-language :thread-index; bh=ERZzffOQ+R5jbKkYDRfSoInRBSnQYLW4v325QV+6NLs=; b=UiE+xUeS46rwSa4gNhdrLY56JJW/QVdnoY6So6udMydBsizANE5mknPCGxh4NT/r7g A02XPI+A7rU1zf7GqIjv+1jTgjDFHUTZBHTASidjkeI9TTVh+LRoa9GhYVyCZi3nXt3D dYF2R/0gsyOYdU1Y8nUWErbwAaxy19x/D3RtbZX0tl2Snxnx3WqifbgBOKgLfAsTxQRh buDZFsq9DW+wNZsRgSaFFpO4O8h2uCcaB9vLAP/SD9B2AMQOQFQIfAkVbZeC3Thvl068 9J6RVSE1QD+1cIMuIIrEiRmOBYERsG/dbdBQIWcCQ5gRLex382nNbHmSS8k+JDiBtxcv gT4Q== X-Gm-Message-State: AODbwcDRqNVqQNB8IR81uqGNHgFf4NDMEBVAaE6RsvMBMwrE+idW1emp HpqLscxtc1W9GqXP X-Received: by 10.223.155.145 with SMTP id d17mr12962292wrc.105.1496088259071; Mon, 29 May 2017 13:04:19 -0700 (PDT) Received: from PC018 (dslb-178-001-020-074.178.001.pools.vodafone-ip.de. [178.1.20.74]) by smtp.gmail.com with ESMTPSA id v62sm14068494wmv.15.2017.05.29.13.04.18 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 29 May 2017 13:04:18 -0700 (PDT) From: "Klaus P. Pieper" To: References: <028501d2d84f$2f1ea840$8d5bf8c0$@gmail.com> <20170529181429.4hicimoro6jqog3s@alap3.anarazel.de> In-Reply-To: <20170529181429.4hicimoro6jqog3s@alap3.anarazel.de> Subject: Re: pgbench Windows outperforms Debian in Write tests while Debian is faster in SELECT only tests Date: Mon, 29 May 2017 22:03:57 +0200 Message-ID: <007101d2d8b6$b4fc5950$1ef50bf0$@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Outlook 16.0 Content-Language: de Thread-Index: AQGliTsjlxOtkJqG1mT2odcKF1E5LQIZsO8BolWMZPA= X-Antivirus: Avast (VPS 170529-2, 29.05.2017), Outbound message X-Antivirus-Status: Clean X-Pg-Spam-Score: -2.5 (--) 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 > -----Urspr=FCngliche Nachricht----- > Von: Andres Freund > Gesendet: Montag, 29. Mai 2017 20:14 > > Windows IIRC defaults to something close to barriers=3D0. I think this explains in simple words what the manual mentions - I just didn't understand it before. 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. Regards klaus --- Diese E-Mail wurde von Avast Antivirus-Software auf Viren gepr=FCft. https://www.avast.com/antivirus --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin