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 1ffQMt-0001NF-UI for pgsql-performance@arkaria.postgresql.org; Tue, 17 Jul 2018 13:50:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ffQMr-0004L0-1w for pgsql-performance@arkaria.postgresql.org; Tue, 17 Jul 2018 13:50:17 +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 1ffQMq-0004KN-6A for pgsql-performance@lists.postgresql.org; Tue, 17 Jul 2018 13:50:16 +0000 Received: from mail-he1eur01on0090.outbound.protection.outlook.com ([104.47.0.90] helo=EUR01-HE1-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 1ffQMi-0007Mm-2D for pgsql-performance@lists.postgresql.org; Tue, 17 Jul 2018 13:50:13 +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=w1ipi24yHBXXyzptSao4XCNaXYJddHSmrCKfUSqhb5E=; b=C1d07wron5PoY5AyXxYY42WGnGrkIr/UQwcKWyXR5g5RP6mSnlLItyogf1paObcUjLIE1OmUBvKHrSd8v6Dn/Xj83RC0UOCo6PojBVri3EIb/n6G1cp/oDF1n8A/FDqzTIHAA/Yhv3Uo1FRa6ZVsvBO1eR3/XVpWovcZTkzEcjc= Received: from HE1PR1001MB0986.EURPRD10.PROD.OUTLOOK.COM (10.168.129.138) by HE1PR1001MB1291.EURPRD10.PROD.OUTLOOK.COM (10.171.95.20) 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 13:50:03 +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 13:50:03 +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+uPeBvyJU6STD3uAgABStQCAAARUAIAABvUAgAABkwA= Date: Tue, 17 Jul 2018 13:50:03 +0000 Message-ID: <5B4DF40E.7080803@sibvisions.com> References: <01bbbc88-2a47-f078-ea40-ab2c1acafa1f@portavita.eu> 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;HE1PR1001MB1291;7:++ujl7az1WpATAKO4PxjRmknD+caL5cITGcIS/zaoWKkoAztGJdA1JEYQ4tDFT5Wz1f+7BJSPY2ur+IkL0RSa+8j4bFNXZ2BJBllOVGWZNpDgCLdVm8TULewMLzF/RW7iiWeYBQvhqZup5dovbmMPxGEQK7B1sC1/enSEv8clEONJ1I051LYQriWqjWV30tCYG76bfJEFojgx+SLSg9zBiuD2w7Vzy+RGFDpOqLVmyRxFdjftond3gCAtKC0GOAj x-ms-exchange-antispam-srfa-diagnostics: SOS; x-ms-office365-filtering-correlation-id: ddbee00d-a709-499b-0e1f-08d5ebec32b1 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:HE1PR1001MB1291; x-ms-traffictypediagnostic: HE1PR1001MB1291: 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)(3231311)(944501410)(52105095)(3002001)(10201501046)(93006095)(93001095)(149027)(150027)(6041310)(20161123560045)(20161123564045)(20161123558120)(20161123562045)(2016111802025)(6043046)(6072148)(201708071742011)(7699016);SRVR:HE1PR1001MB1291;BCL:0;PCL:0;RULEID:;SRVR:HE1PR1001MB1291; x-forefront-prvs: 073631BD3D x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(396003)(136003)(39830400003)(376002)(346002)(366004)(189003)(199004)(6116002)(93886005)(25786009)(8676002)(97736004)(81156014)(3846002)(80316001)(6246003)(53936002)(7736002)(305945005)(256004)(6506007)(86362001)(53546011)(2616005)(476003)(81166006)(2900100001)(65816011)(76176011)(446003)(14454004)(66066001)(11346002)(87266011)(26005)(106356001)(186003)(316002)(6916009)(5660300001)(2501003)(6486002)(5250100002)(6436002)(102836004)(99286004)(2351001)(486006)(478600001)(59896002)(8936002)(558084003)(33656002)(229853002)(5640700003)(105586002)(2906002)(6512007)(68736007)(44832011)(36756003);DIR:OUT;SFP:1102;SCL:1;SRVR:HE1PR1001MB1291;H:HE1PR1001MB0986.EURPRD10.PROD.OUTLOOK.COM;FPR:;SPF:None;LANG:en;PTR:InfoNoRecords;MX:1;A:1; received-spf: None (protection.outlook.com: sibvisions.com does not designate permitted sender hosts) x-microsoft-antispam-message-info: eqBefbYm7UIbIGfVgU5VQfXg6uOgMZ03M+Fl5NtLsHIHuF0vXkvvH6PmK5kNi20fSt/Z3bWI3WBcgbEr2FGSrzkEMa7zKT3UtcRkut7dhleCZwAFgbVX2BiXsDjbE4pwUC0nwd8GqHB7Ki4FAXAprlVXgA4o7C53/s5Pr0oBoSNl4bi0PeB77Pec1B6TlM7Hp7uiofmrWhHWBaCehBfyV9xkjPt9irOFk0Au0pDJlXQz6NnUa21Qqsr4OG6kNPT2wCVOpFyZxB15uDxAGkPtIH48exmOQGVakW/n5Q6rzNvWYXwK9yx0l20BnLa2DnpBtg85zH2ysuaT2DQdaJ46Xw/b5Y+NnKOUDzWCMjYR+e8= spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: text/plain; charset="utf-8" Content-ID: <9E74FEB21387354DB4C5F82300248FED@EURPRD10.PROD.OUTLOOK.COM> Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: sibvisions.com X-MS-Exchange-CrossTenant-Network-Message-Id: ddbee00d-a709-499b-0e1f-08d5ebec32b1 X-MS-Exchange-CrossTenant-originalarrivaltime: 17 Jul 2018 13:50:03.6325 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: beb1b6aa-9998-4674-9056-cbc4fe8c7cad X-MS-Exchange-Transport-CrossTenantHeadersStamped: HE1PR1001MB1291 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk T24gMTcuMDcuMjAxOCAxNTo0NCwgTmljb2xhcyBDaGFybGVzIHdyb3RlOg0KPiAtIFBhcnRpdGlv bnMgaXMgbm90IGNvcnJlY3RseSBhbGlnbmVkIG9uIHRoZSBTU0QgYmxvY2tzDQoNCkRvZXMgdGhh dCByZWFsbHkgbWFrZSBhIG5vdGljZWFibGUgZGlmZmVyZW5jZT8gSWYgeWVzLCBoYXZlIHlvdSBn b3Qgc29tZSBmdXJ0aGVyDQpyZWFkaW5nIG1hdGVyaWFsIG9uIHRoYXQ/