Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ffKbX-0004XT-8q for pgsql-performance@arkaria.postgresql.org; Tue, 17 Jul 2018 07:41:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ffKbU-00052w-QC for pgsql-performance@arkaria.postgresql.org; Tue, 17 Jul 2018 07:41:00 +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.89) (envelope-from ) id 1ffKbU-00052p-30 for pgsql-performance@lists.postgresql.org; Tue, 17 Jul 2018 07:41:00 +0000 Received: from mail-eopbgr80098.outbound.protection.outlook.com ([40.107.8.98] helo=EUR04-VI1-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ffKbP-0007Le-UI for pgsql-performance@lists.postgresql.org; Tue, 17 Jul 2018 07:40:58 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=sibvisions.onmicrosoft.com; s=selector1-sibvisions-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=oKrwp9tlOFHzaryJjbhvfgJgS9iMM3GjWEMc+li+8KA=; b=dI6npXYt8LOR7DhNyFMVDh+qXdJUoTCT946+ODzN9IRKTe8HVE91KnFWqngvhdsTPagO7qkFWsLlWzbOTTtetmiLHj1zULZ8dt51fPqXnXN6oR3Omak73DdfxOmKYOYvDurmPyTLRWX9+jbBZCNXY2dZzW/OWj4vTId9XUcii0U= Received: from HE1PR1001MB0986.EURPRD10.PROD.OUTLOOK.COM (10.168.129.138) by HE1PR1001MB1388.EURPRD10.PROD.OUTLOOK.COM (10.171.98.146) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.952.21; Tue, 17 Jul 2018 07:40:51 +0000 Received: from HE1PR1001MB0986.EURPRD10.PROD.OUTLOOK.COM ([fe80::f0af:d5d7:9167:da9]) by HE1PR1001MB0986.EURPRD10.PROD.OUTLOOK.COM ([fe80::f0af:d5d7:9167:da9%8]) with mapi id 15.20.0952.021; Tue, 17 Jul 2018 07:40:51 +0000 From: Robert Zenz To: "pgsql-performance@lists.postgresql.org" Subject: Re: Why HDD performance is better than SSD in this case Thread-Topic: Why HDD performance is better than SSD in this case Thread-Index: AQHUHYsvHE8OGIzLMUSW+uPeBvyJU6STB+UA Date: Tue, 17 Jul 2018 07:40:51 +0000 Message-ID: <5B4D9D86.2000307@sibvisions.com> References: In-Reply-To: Accept-Language: de-AT, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: spf=none (sender IP is ) smtp.mailfrom=robert.zenz@sibvisions.com; x-originating-ip: [213.164.18.106] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;HE1PR1001MB1388;7:DYPVaKTXsSDx9x+e8YHCAkvF7Ly/yVp9lcP6uEmmSbBcRtjSvZ6XICwmt8QuyzI6Zm80Ocint6r2N9lRCu1Mi9pS7YVFOW74kUyvzfEVLnfurMi8EI5jrfATydZ+rIgebc/v1XlngKiKyDJ5kHqyahu4KJptv8X6uaIEFCBRNtNQBiiwwMNm8BTIIqSbajZ2qBaEpScQdRLXglxZRPYPTU6XbV6mZSHOIT6wP4ZeG56CN6UyEpK6uMeWD5Qa1VIx x-ms-exchange-antispam-srfa-diagnostics: SOS; x-ms-office365-filtering-correlation-id: 76805eda-7863-4953-7665-08d5ebb89ecb x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:(7020095)(4652040)(7021125)(8989117)(5600053)(711020)(4534165)(7022125)(4603075)(4627221)(201702281549075)(8990107)(7048125)(7024125)(7027125)(7028125)(7023125)(2017052603328)(7153060)(7193020);SRVR:HE1PR1001MB1388; x-ms-traffictypediagnostic: HE1PR1001MB1388: x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:; x-ms-exchange-senderadcheck: 1 x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(6040522)(2401047)(8121501046)(5005006)(3002001)(3231311)(944501410)(52105095)(93006095)(93001095)(10201501046)(149027)(150027)(6041310)(20161123560045)(20161123558120)(20161123564045)(2016111802025)(20161123562045)(6043046)(6072148)(201708071742011)(7699016);SRVR:HE1PR1001MB1388;BCL:0;PCL:0;RULEID:;SRVR:HE1PR1001MB1388; x-forefront-prvs: 073631BD3D x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(136003)(366004)(346002)(39830400003)(376002)(396003)(199004)(189003)(2351001)(80316001)(33656002)(6116002)(3846002)(59896002)(5640700003)(99286004)(6512007)(186003)(106356001)(229853002)(2501003)(2900100001)(36756003)(5250100002)(6436002)(6486002)(26005)(7736002)(25786009)(8676002)(81156014)(8936002)(305945005)(105586002)(81166006)(11346002)(478600001)(486006)(6916009)(256004)(316002)(558084003)(14454004)(44832011)(97736004)(5660300001)(2906002)(53936002)(6246003)(76176011)(68736007)(2616005)(86362001)(6506007)(65816011)(102836004)(476003)(87266011)(446003)(66066001);DIR:OUT;SFP:1102;SCL:1;SRVR:HE1PR1001MB1388;H:HE1PR1001MB0986.EURPRD10.PROD.OUTLOOK.COM;FPR:;SPF:None;LANG:en;PTR:InfoNoRecords;A:1;MX:1; received-spf: None (protection.outlook.com: sibvisions.com does not designate permitted sender hosts) x-microsoft-antispam-message-info: Vsz3UtPtNXe/Nm5rtgv9JJLLfg+uPKx4BRzec7nDp8RlUChx1XOeDoRyfWCdSEGvURSdceOKVzA8xTKFcFW3zInfpzVpBuGfUM7PnOIL/BFrO8C9co0rZElAsotbUdOTuzBxN2aQDx4u33NZdDkOIR4o1QadO9VrfBeqbPsa+bM9Z0AHhiFU284DoniiyC8DE28hoCPB0BbSE0B6CMctZ0PyeFNYOcj9eQAW6vEWUGu7ptsW/eo8eInrVS5guy1CDHNAqmqMIyUE8AVBPzLB6lkowbgJrm0tlSidRvXqlSz/GQWwV0+vKOagZ6q6hEyRtHel56ywN0fXPA6HgeUsiKcY/lWqU4ua/i8zsi/w4lE= spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: sibvisions.com X-MS-Exchange-CrossTenant-Network-Message-Id: 76805eda-7863-4953-7665-08d5ebb89ecb X-MS-Exchange-CrossTenant-originalarrivaltime: 17 Jul 2018 07:40:51.2116 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: beb1b6aa-9998-4674-9056-cbc4fe8c7cad X-MS-Exchange-Transport-CrossTenantHeadersStamped: HE1PR1001MB1388 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk PiBXaHkgZGlkIHRoZSBIREQgKDcyMDAgcnBtKSAgcGVyZm9ybSBiZXR0ZXI/DQoNCkFyZSB0aGVz ZSBkaWZmZXJlbnQgc3lzdGVtcz8gSGF2ZSB5b3UgcnVsZWQgb3V0IHRoYXQgZHVyaW5nIHRoZSBI REQgdGVzdCB0aGUNCmRhdGEgd2FzIGF2YWlsYWJsZSBpbiBtZW1vcnk/