Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eF193-00035L-4h for pgsql-admin@arkaria.postgresql.org; Wed, 15 Nov 2017 17:06:37 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1eF192-0004ds-3M for pgsql-admin@arkaria.postgresql.org; Wed, 15 Nov 2017 17:06:36 +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 1eF191-0004dI-B2 for pgsql-admin@postgresql.org; Wed, 15 Nov 2017 17:06:35 +0000 Received: from mail-wm0-x22b.google.com ([2a00:1450:400c:c09::22b]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1eF18t-0001xs-AH for pgsql-admin@postgresql.org; Wed, 15 Nov 2017 17:06:34 +0000 Received: by mail-wm0-x22b.google.com with SMTP id z3so4394254wme.3 for ; Wed, 15 Nov 2017 09:06:26 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:subject:date:message-id:mime-version:thread-index :content-language; bh=rpt/+8ym5GRgbWhJsfmtQ6aBdA4F1Jm1XA9nZJbcnEU=; b=D/xEYrGonJDD7Cd/lFdesZ+NgRodwkeDoHtdj5A477S1JDH0/At5Hjmyk1sTIFMfZo GAg7LUw5P+QnX9QlTrxj65KrwYxm83xQlkBA8PJ8LXnCiL3P/iUh8rFiuF2mxNI29CGZ DPUB4RbXjcZppKvsTFX/fq0Kf1sk5DMNRjpUnTqLJWSI2cc53Xgt9iobuek0MD2116kG vljZjbdL2fWgWx7ima5Vv8Igj7STb+jUTNzi4OGdmjI5cRa2QFNJkE0jhwdztQ0VypEg KzBf+zMNhh60IQtfRRx3fO0d+nSR0MHhpOQzfv54yF01NG+XO6JpOwQqaH6dPPOVHJ1X DRPA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:subject:date:message-id:mime-version :thread-index:content-language; bh=rpt/+8ym5GRgbWhJsfmtQ6aBdA4F1Jm1XA9nZJbcnEU=; b=SRcgbVhOa5ZrBgTlrs8K/RwsggwuOIvdF7NO7r83Cno80WVhL/AaDhV5YJeWaHaTt0 0w+3Z84rYO+LIXOcMhaNPL14qPvga/Rel8UIFtqbdPZnLHwZJN/YWdrpLsr+FB8DiZkp vJRvuGlz57ITG+eYlAXULPzj16X1cAeM+hIDDcUo1g2LGdYkGdu7pUG/05lHgenWR3wU ziYTQGVc2xzNc+CfhcaBP6GfzKlEFoJNRQofJfaCNeJd/rVLwEuoEX1cjmG3/5V82N3N EomR3suuMQrujwVej/x8ds1WpBPMaTGl+dZgor88CHghIHBNtGY3XxtwsfoOc00Qsjsr easw== X-Gm-Message-State: AJaThX75Vg28Unt6BCqeqDNZSVCluSS/FHHptZSWT0KIQncTFasF8HT5 j3f4wOsPt6cYkbX+vZmE3tHZ7w== X-Google-Smtp-Source: AGs4zMYPdU8K0CwZXqKB6su5g0o2vAYmStFzHR8DK6+iLHOMhwN7vCDXpQQPfHjL2qrUbv8pKjzVOQ== X-Received: by 10.80.136.49 with SMTP id b46mr23673049edb.238.1510765583900; Wed, 15 Nov 2017 09:06:23 -0800 (PST) Received: from PC016 (mail.ibeq.com. [212.100.42.241]) by smtp.gmail.com with ESMTPSA id h16sm17454390edj.33.2017.11.15.09.06.22 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Wed, 15 Nov 2017 09:06:23 -0800 (PST) From: To: Subject: Performance difference between servers Date: Wed, 15 Nov 2017 18:06:22 +0100 Message-ID: <007c01d35e34$10a7f770$31f7e650$@gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_007D_01D35E3C.726C5F70" X-Mailer: Microsoft Outlook 16.0 Thread-Index: AdNeMCI6y0XbkYWrSUKixALeZKqS1g== 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_007D_01D35E3C.726C5F70 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_007D_01D35E3C.726C5F70 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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

 

------=_NextPart_000_007D_01D35E3C.726C5F70--