Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eF1Lv-0003tK-3A for pgsql-admin@arkaria.postgresql.org; Wed, 15 Nov 2017 17:19:55 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1eF1Lu-0000wk-Mk for pgsql-admin@arkaria.postgresql.org; Wed, 15 Nov 2017 17:19:54 +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 1eF1Jy-0003Sp-HE for pgsql-admin@postgresql.org; Wed, 15 Nov 2017 17:17:54 +0000 Received: from mail-wm0-x230.google.com ([2a00:1450:400c:c09::230]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1eF1Jt-0002Ba-I7 for pgsql-admin@postgresql.org; Wed, 15 Nov 2017 17:17:54 +0000 Received: by mail-wm0-x230.google.com with SMTP id z3so4488435wme.5 for ; Wed, 15 Nov 2017 09:17:49 -0800 (PST) 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 :thread-index:content-language; bh=5R3Xzpr+JaI+3Hr+Ecsl0SuyjBfS05nur3wWy6eYcII=; b=m972YfQc8Y1EhhNVCZG6AKPMHziDcpZ+Ws6EhoEVuMGGQPYGfsfEOlFFS+oTUQmAxp StqKu1VC6fLi7gjAbP8VpB+JBh7f2kAWI/l/d2DJG4hVoLtMN3ThChffcaGS85S5BUdq IRI5dic5ubQ8ozHQBP+RCysd36Gv3nfF3G7l3IZTmmMxDklvf0Q0xiRWZPJxZZjSu1O1 lrnqYYPz2jxk1N2cPgmqdW1Y1GqvgIakx3VkbQLGiDHs9t3fW14Qr+0Y4y05G/J+x1tj BxiTYcECWbjzdsdIMmtp8IwligCgSWU54xjKAQPUBdAuOpbsKQCWalBp/8zxIK7WCOgv WaHw== 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:thread-index:content-language; bh=5R3Xzpr+JaI+3Hr+Ecsl0SuyjBfS05nur3wWy6eYcII=; b=YXD+GkLVRPcVwKaXDMeeqte+BlUPkl/z0DOMzuU8NbtYnzFU+5Kybe8Jn7INNVPlB0 Nrt6tc6ecYjvykYahck1JRi5Mu++Ib6ZvltGdqaNQ7+1C4Qst40qbUgmx7cOqfv4M9SQ 8bWrXoszddy+OHlgwb8kq8LyiMrYbw9NIdeHdNETs+GbyBuyjY0+vxB3o45ODF6HlDt8 5MJ3XmsQGiBcdoUE1BCnnH4bjJL2/E3Osn0BpxSOTR36BUmRzBaBW4T9wZpxyM58o9Jo OPZMQhvea80VsUOn54XqytVdPb7khulDOKL9RX2TFboo6f562COCO3DAkFtM0KVGAFJN JDeQ== X-Gm-Message-State: AJaThX6UUC5pZLD0dCzyMBg0bNiJ+s52A0ioD8JmRqDTprDlI5tRqAMV EZt9P+K6WwFgQ1JkYYSyItGN5g== X-Google-Smtp-Source: AGs4zMZJZvn2SoqQ4hO8DTZxCgWrZnxd9TAlp4UbIFSKJwRmsidbuoZDrB/jC8MTVHaHy2n2CTm05w== X-Received: by 10.80.208.10 with SMTP id j10mr23227046edf.194.1510766268474; Wed, 15 Nov 2017 09:17:48 -0800 (PST) Received: from PC016 (mail.ibeq.com. [212.100.42.241]) by smtp.gmail.com with ESMTPSA id h16sm17475867edj.33.2017.11.15.09.17.47 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Wed, 15 Nov 2017 09:17:47 -0800 (PST) From: To: References: <007c01d35e34$10a7f770$31f7e650$@gmail.com> In-Reply-To: Subject: Re: Performance difference between servers Date: Wed, 15 Nov 2017 18:17:47 +0100 Message-ID: <000401d35e35$a8bf18d0$fa3d4a70$@gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0005_01D35E3E.0A868E10" X-Mailer: Microsoft Outlook 16.0 Thread-Index: AQNaLifc2PYzL3c8wJpjGYbbDmQX5QHVAdAjAqWc9rk= Content-Language: de 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 This is a multipart message in MIME format. ------=_NextPart_000_0005_01D35E3E.0A868E10 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Yes, exactly: Three different (hardware) machines, each having a hyper-V host and the Windows Servers as Hyper-V guests. Von: Scott Whitney [mailto:scott@journyx.com] Gesendet: Mittwoch, 15. November 2017 18:11 An: kpi6288@gmail.com; pgsql-admin@postgresql.org Betreff: Re: [ADMIN] Performance difference between servers Are you saying that each of these servers is a virtual HyperV machine running under a hardware host? _____ From: pgsql-admin-owner@postgresql.org > on behalf of kpi6288@gmail.com > Sent: Wednesday, November 15, 2017 11:06 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] Performance difference between servers We have 3 different servers, one (the oldest) ist significantly faster at certain operations and I can't find out the reason: (table created in monospace font) Server Processor RAM CrystalDiskMark pgbench CREATE DATABASE OS #1 i7-2600 8GB 495 / 473 26.000 4.5 . 6 s W/ Server 2008 R2 on Hyper V Server 2008 #2 E3-1245 16GB 797 / 514 50.000 13 . 19 s W/ Server 2016 Std. on Hyper V Server 2016 #3 E3-1270 12GB 933 / 334 40.000 13 . 20 s W/ Server 2008 Essentials on Hyper V Server 2016 CrystalDiskMark: "Seq Q32T1" Pgbench: pgbench -i -s 200 -U postgres pgbench pgbench -c 40 -j 10 -T 150 -U postgres -S -P 5 pgbench CREATE DATABASE: create database test with template myTemplate All running PostgreSQL 9.6 x64 with similar configuration. All running as virtual machines, no other virtual machines creating any load. Using the same template database on all machines. Although the indicative numbers of pgbench and CrystalDiskMark show better values for server #2 and #3, server #1 creates a new database considerably faster. All servers have SSDs. Server #1 has two single SSDs (a system disk and a data disk). Servers #2 and #3 have only one logical disk for system and data, and this is two SSDs running as RAID 1. This may be slower but if it is, I would excpect this also to show up in the pgbench results. The reason behind this exercise is that a test application was also reported to be slower on server #2 and 3. Any idea how to track down the performance difference? Thank you Klaus Journyx, Inc. 7600 Burnet Road #300 Austin, TX 78757 www.journyx.com p 512.834.8888 f 512-834-8858 Do you receive our promotional emails? Click here or visit http://journyx.com/communication-preferences to unsubscribe. ------=_NextPart_000_0005_01D35E3E.0A868E10 Content-Type: text/html; boundary="----=_NextPart_000_0084_01D35E3D.C53CF9C0"; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Yes, = exactly:

 

Three = different (hardware) machines, each having a hyper-V host and the = Windows Servers as Hyper-V guests.

 

 

Von: Scott Whitney = [mailto:scott@journyx.com]
Gesendet: Mittwoch, 15. November = 2017 18:11
An: kpi6288@gmail.com; = pgsql-admin@postgresql.org
Betreff: Re: [ADMIN] Performance = difference between servers

 

Are you saying that each of these = servers is a virtual HyperV machine running under a hardware = host?

 

 

 

<= div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'>

From: pgsql-admin-owner@postgr= esql.org <pgsql-admin-owner@postgr= esql.org> on behalf of kpi6288@gmail.com <kpi6288@gmail.com>
Sent: Wednesday, November 15, 2017 11:06 AM
To: pgsql-admin@postgresql.org=
Subject: [ADMIN] Performance difference between = servers =

 

=

We have 3 different servers, one = (the oldest) ist significantly faster at certain operations and I = can’t find out the reason:

 

(table = created in monospace font)

 

Server  = Processor  RAM   CrystalDiskMark =   pgbench   CREATE DATABASE =   OS

  #= 1    i7-2600   8GB     495 = / 473   =      26.000      4.5 = … 6 s      W/ Server 2008 R2 on Hyper V = Server 2008

  &= nbsp;#2    E3-1245   16GB    797 = / 514    =     50.000      13 … = 19 s      W/ Server 2016 Std. on Hyper V Server = 2016

  =  #3    E3-1270   12GB  =   933 / 334        = 40.000      13 … 20 = s      W/ Server 2008 Essentials on Hyper V = Server 2016

 

CrystalDiskMark: „Seq = Q32T1“

Pgbench:

   pgbench -i -s = 200 -U postgres pgbench

   pgbench -c 40 -j 10 = -T 150 -U postgres -S -P 5 pgbench

CREATE = DATABASE:

   create database = test with template myTemplate

 

All = running PostgreSQL 9.6 x64 with similar configuration. All running as = virtual machines, no other virtual machines creating any load. Using the = same template database on all machines.

 

Although = the indicative numbers of pgbench and CrystalDiskMark show better values = for server #2 and #3, server #1 creates a new database considerably = faster.

All servers have SSDs. Server #1 = has two single SSDs (a system disk and a data disk). Servers #2 and #3 = have only one logical disk for system and data, and this is two SSDs = running as RAID 1. This may be slower but if it is, I would excpect this = also to show up in the pgbench results.

 

The = reason behind this exercise is that a test application was also reported = to be slower on server #2 and 3.

 

Any idea = how to track down the performance difference?

 

Thank = you

Klaus

 

=

 

 

Journyx, Inc.

7600 Burnet Road #300
Austin, TX 78757
www.journyx.com =

 

p 512.834.8888 

f 512-834-8858 

 

Do you receive our promotional emails? Click here or visit = http://journyx.com/= communication-preferences to = unsubscribe.

------=_NextPart_000_0005_01D35E3E.0A868E10--