Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oPoPM-0003DQ-2w for pgsql-admin@arkaria.postgresql.org; Sun, 21 Aug 2022 17:06:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oPoPK-0005vo-VA for pgsql-admin@arkaria.postgresql.org; Sun, 21 Aug 2022 17:06:42 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oPoPJ-0005ve-If for pgsql-admin@lists.postgresql.org; Sun, 21 Aug 2022 17:06:42 +0000 Received: from mail-db8eur05on2081.outbound.protection.outlook.com ([40.107.20.81] helo=EUR05-DB8-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oPoPG-0005Z2-PI for pgsql-admin@lists.postgresql.org; Sun, 21 Aug 2022 17:06:40 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=emoGD2BN7nxfVxNM5ioMFRwDO2gVlL9DL6C39/moczi8Io+IajNwQYLzn6johlKfMSWQtFIuQz5libF2a+SehiFxQ1dVVpK1Me69si2/IbLzEMEwAFISlJg19WyAIrIFLMclmH3rhLWmJbVf1cGAUAtkW15fQEswUgYprD+HVTWzcvoowPWVxWOQayi2dlHkhny0dmHaTbnMBAKfGLdKwzHVMJYC0dzMPL1Eh9NyxWByh+BB05LsGWkB66y+vy9R9KxGmHsNm0v6CkrFsBzSlhoJ8ZL4KdNBIfx7qfi4UIy7lMRy2Gt8c2ZQLaGJZzM0LNdR3D0FmZBHJE0eUPzeQQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=NIkwkEiItHMv05+v2Xqwcw1EX6ekNPwzIdk0NnFpp3c=; b=XPfO4ETCwAZ0M166S/Sa2lwFr/2mNBPSbDv45zy/ZsWnEc8i6Ws4T6W5O050du1juhtPOjXTe41OqxaLYjfBGqvY+yTg6zX9ZsgLuCB8QyQAJ0Sud/EPNWXQErtnE/rDqwA/5uoKGzhKoCt1vPqxXrSV1Ktglgcj9mAvPGRB1G5qj2ha2yHRe9rJYv7Pj6TXzbw6sVk/HZ3wsH5yKU2Ch1um52xkQ//pGb8EaoPDdoxcRrKLMr25kHI4tRAccJ25kjTybMIIeZaiKOX6bJPQgT5wChutWgEprBUKaknFq6o1VUG5sEPDqwYyt+dC8etLTlaTBzUC0QucHhB2lJe8lA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=ucll.be; dmarc=pass action=none header.from=ucll.be; dkim=pass header.d=ucll.be; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ucll.be; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=NIkwkEiItHMv05+v2Xqwcw1EX6ekNPwzIdk0NnFpp3c=; b=JEeyIQIWPmQ3ES91QoBoljCn3h4jcMfuA7f55KVAgLrv1dpRW7C+0CoH/jfHjrA14NAerubby5YYELJZibIPVg93uHuG1furzcdf3jzCt0jWX57gIi+M2vVqL1fr2wLvMpD7WnZqPjJXM8GW0N++RdUrfdY41ysdH1uVh9jYq3E= Received: from AM9P195MB0790.EURP195.PROD.OUTLOOK.COM (2603:10a6:20b:1ff::22) by AM8P195MB0867.EURP195.PROD.OUTLOOK.COM (2603:10a6:20b:1ca::22) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5546.16; Sun, 21 Aug 2022 17:06:35 +0000 Received: from AM9P195MB0790.EURP195.PROD.OUTLOOK.COM ([fe80::6dbb:cca4:7fbc:58fa]) by AM9P195MB0790.EURP195.PROD.OUTLOOK.COM ([fe80::6dbb:cca4:7fbc:58fa%4]) with mapi id 15.20.5546.022; Sun, 21 Aug 2022 17:06:35 +0000 From: Wim Bertels To: "kenny.bachman17@gmail.com" , "pgsql-admin@lists.postgresql.org" Subject: Re: Postgresql 14 performance Thread-Topic: Postgresql 14 performance Thread-Index: AQHYtXfss028CstYhE6cH73BbgPYeq25lcsA Date: Sun, 21 Aug 2022 17:06:35 +0000 Message-ID: <15d5ba26a5d3b8fef5e88372f8438840bee3d36f.camel@ucll.be> References: In-Reply-To: Accept-Language: nl-NL, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Evolution 3.38.3-1 authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=ucll.be; x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 5c2ce306-3d54-4930-f482-08da839780d1 x-ms-traffictypediagnostic: AM8P195MB0867:EE_ x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: 7DtUzsGvOhyqlQen/dGNJ57Sw2w3Z+YDPLO/AJsy6DvdYFO8N32rXgcEF35ZBHtd9sg+KT59avl1omu4AEb8YwIkaYeO4NiKOHTvDqf98WW9gnQ/swG+Io7rwlczRxWWqmu40lZfZiNy0ZDEyk6A2nwnyzDBH2p6BVjbPSDJWWFEprvBUl+vxrYKPKyZnTbL85MmZ6j6UzxPuXS7977zmVOlUOCgt6FhH3k+t0OdBGs4bg2r79O2dFNDRaCmQNSaWNiMPOoGLo9usOfQ6ErCQDoZPV3h+v2g2QOqUs9bVCia85fFeUa3h5uiV6hrUvqm2IDX7SXG2EhdFUB1ISbeolsu+wwIWl+pBBT080AIbRoRhxyE+HqrC84kBaECoZ67D2crK5aNrBjDkrfkC8JJRvqfobYucOPsjQp17Nk8iIjxag/Hr4x2sjzm8OXaRzmByoNMuxmdfAgjKVLV12Y5ClwafIoL2gKb/cYzpAhPm0ErAjHamukOVAOstLuRKe6gIqRQYFXY0FOvXL6SnB49RfRnkoND3iq33KBIU0KALJ0mnK0At+T7Jp8ALkPyctYbpUSFpbmawlVmQ8Z+VA2OGfTKKPNSyDzq1btczihlDI3YnVNpIXKyY/2ZFXttmUeT3qh0H+hddKKp6Pbh9gp7+9ViFxjbO7HrdnyiRLDBOHAV98uOo+juBwzv77ahysUr7icEBklOab3pvruJgMaiiBNKvpvCjxgUD9Zunmgr3pBW6x45K+BvOwcAGuc/KxdlRNDJuc0wNI+t/zEODkKUxQ== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:AM9P195MB0790.EURP195.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230016)(4636009)(376002)(346002)(136003)(366004)(39850400004)(396003)(76116006)(110136005)(66946007)(8676002)(64756008)(66446008)(66476007)(7116003)(66556008)(6512007)(786003)(316002)(38070700005)(86362001)(6506007)(2616005)(186003)(122000001)(71200400001)(83380400001)(478600001)(6486002)(41300700001)(8936002)(44832011)(38100700002)(2906002)(5660300002)(41320700001)(36756003);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?eVE2Uno5OHYzc3VqTElzTVdkZ1BjYXJSQXViSCtlUEVrQUJ0VnkrQUFQbEp4?= =?utf-8?B?QWg2RkdLbVdlZ29ncG1aWk9Uc3BwY0RXN1VvbDU0dStEUU4vNTNHd2RTVnBj?= =?utf-8?B?SnJrTENRNURuNkZnWnJHUHJ3ckIzc3Bjd1h4K1J5QzJQUm1haFNzZXd5NnJT?= =?utf-8?B?NjFMaXk1MUlFcktaSnlia0w0elFXZlFyUjF3azRnNmx1aVBnNEtDU25KaHhi?= =?utf-8?B?cjZrbi93MG9lWE5OY2tHNjlGUmhWYjRiUXJOSmlEN3QzbjlGWHdKM1lrbnR3?= =?utf-8?B?VStreU00emlvU21CS2FXMko4ZnBpMnYrTDd6bGJuY2VCeFFhL29Nd0F0MEpy?= =?utf-8?B?U1pHODN6Q2tyTG9PT3RSZHZOZWdzRUNiUUoxSjBIL3JrWXFKUjRERmwwSVJL?= =?utf-8?B?NHdxbzl2NE14THhnMmlQZFh4aTBUQm1ieEJQbkxzZ3BQd2lMeWNPOVc2OVNX?= =?utf-8?B?eS9VUmgvbTROV2tnL21CWXlDUWlyRFVHVFgxbnhxN2VHNG43eG50RmkyMm9r?= =?utf-8?B?WEhnQ2lYZTFyMTRhRzZNWk9wa1JwcjdPYnVmaW9Ld3N3MEcwQWRQanVwdHcy?= =?utf-8?B?QkI4V2ZjQnVKTnhwVHlBTUpuRXlsUThRVTZyVWV6OWdvdVQvdVZMeS9lOE1h?= =?utf-8?B?WTNvTDVIRG9EelJpY2dGRXBjTU84clFuTFhDbERBeXdCTXA1cDlXelQwYW95?= =?utf-8?B?bk9BMWVJalZWcWdPM1pWSjY3UFpTT2RqNTg5SFV4aUlOamIrQ3IrWjFDOE1I?= =?utf-8?B?VlkxamZ5MVdZN2t2QUF0Yk1BNnVheGNXTHVxbVlJbEloUDEyNFFWSFQ5UCtO?= =?utf-8?B?NlFlcXk1Q0kxQlNlYzdsd2NWVjY5T3hoamZSVVhqSFpTdXl1Q1NtRktTQ0FV?= =?utf-8?B?WFc4RkZFQnU5NkdLQ1doa09jMUJyZjhONmtadndUMG45VHpnTUR5OWZVblhn?= =?utf-8?B?K1p6a1RiZXp4V2tYMENOb3VERUYzaXhKUGdDbnNkblFYRHpqUUp4RjdVUTFz?= =?utf-8?B?R2tIaUtHZXJZaGZ4Wk4vaFVPc0xOTWZnZXVsejk1UmVwQTJ2YUY3ZDN0QWpT?= =?utf-8?B?S3IwdkhOdEpVeXFhRHhxNHFrcEJyY2doSjhFeGRLZHFzd1J3dTdKQXl2c2cy?= =?utf-8?B?WjkrQ1A5RjhPa0JWOW9xTnpzR2xlZ20xQVFuWGdwMEFOQ0IwcXcxRmlva1kr?= =?utf-8?B?S1RDWEI1UzVtb0FCbFNLcjgxVkZmVGw4MHNhb3ByYmNkTzhjcmUvTENZUDNG?= =?utf-8?B?Tzdxcml1YUtQNllRZnByZ2hXZjdPdFVEWkNqbi85eS95blFGVmhBRngrVExV?= =?utf-8?B?T21xV080clZaL3pxUVR3WmE3ajNVVklLc1JYcE1RdkdGRGhPb0dSb3d6WVFQ?= =?utf-8?B?UWRUdXVLdzZiaFBHTVJQaC9rSG5wTGJFcVhYQkZ5SC9HalhLVUVSdkxEamsz?= =?utf-8?B?R3M3R2h0aUw4eHc3ZGtYbHlTR3ZuZGZFNzI5cTMvdlp4V0t2RFhoSXNWOS9H?= =?utf-8?B?WGRDdVk3WGhLc2F1TVlucTNEOWZWOGJ3bHlITXVGSGRycGxPODZaREpGSkV2?= =?utf-8?B?M213MldZczFjMlJHQ3hhbHNxd0pDUWhNK0tTNkFITDYxWVlta0VUYmRwRktH?= =?utf-8?B?dU1LUWN3dGp2TnNNUDVDMHV6OGxBNDRDUW1PelB2bHk5cnR1QjNhNEdpK0tL?= =?utf-8?B?cVVxL1pWMytVYklaOEg0QTNiK3RhZVEweDFUOUtoQ2dsUWd6YVJGRVRvWVVH?= =?utf-8?B?OHpiWnpBbW1MU21qbHpqU1dheTMva2tOYlhxNlF2d2YxZmRTSGhJR2Q2S09T?= =?utf-8?B?aFFIenpOa25wbmpabVl4N0FibkR3dFZYQ3VrV1Ixa2pFMTdvMmt1VHQyUXNs?= =?utf-8?B?SE9zVmRkekRweFpPY2hsS3ZKdVN6NmJBUUlyRUNraU1TdG5yZk83N2VaeGRP?= =?utf-8?B?VFlNM00yNEIwZVZ5Q1dzN3J1b3g0ZkdTVUJZNTdNSDcvMVRORmgyVFBRTG9M?= =?utf-8?B?d29oVmZkODlMU1NuZStzRmJlYWN3NDNSdHgyUzBCbm5BZnBicSsxSHB2M1NM?= =?utf-8?B?dG5paXhTUDRLWTYwNVYvS0phMUdyWWR1MDhJa3ZnV3pSRHpiOUZHSUUvbEps?= =?utf-8?B?NzNwZEkzbkd4a1JENW12RFZpM0tPNm5pR0lTZ2kxM3dpZTdVYVFvNVlVT2Zz?= =?utf-8?Q?xwlguhNStCUSI9UXOFS5lsf4tumrH9XXLCgroPStWXbR?= Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: ucll.be X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: AM9P195MB0790.EURP195.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: 5c2ce306-3d54-4930-f482-08da839780d1 X-MS-Exchange-CrossTenant-originalarrivaltime: 21 Aug 2022 17:06:35.0421 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: e638861b-15d9-4de6-a65d-b48789ae1f08 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: 8xgMvXyyFUJDXF2ZVpEDt5p1JJMiis7y7As4GzXwOsSVQ2tEQxbyt1gEoUDwK92IWaiIkzwbRy+b47kDGAWZAA== X-MS-Exchange-Transport-CrossTenantHeadersStamped: AM8P195MB0867 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGVsbG8gS2VubnksDQoNCmhhdmUgeW91IHRyaWVkIHRvIGNvcnJlbGF0ZSB3aXRoIHRoZSBzeXN0 ZW0gbG9hZCBmb3IgZXhhbXBsZT8NCg0KYWxzbywgaXQgaXMgbm9ybWFsIHRvIGhhdmUgdmFyaWF0 aW9ucywNCmFsdGhvdWdoIGJpZyB2YXJpYXRpb25zIHVuZGVyIHRoZSBzYW1lIGNpcmN1bXN0YW5j ZXMgbWlnaHQgaW5kaWNhdGUNCmFub3RoZXIgcHJvYmxlbSBvbiB0aGUgc3lzdGVtIChzb21ld2hl cmUgaW4geW91ciBody9zdyBzdGFjaykNCg0KLS0NCg0KYSBxdWljayBsb29rIGF0IHRoZSBxdWVy eSArIHBsYW46DQoNCi4uV0hFUkUgIkV4dGVudDEiLiJEZG9JZCIgPSAxNTA2MDc0IE9SICJFeHRl bnQxIi4iRGRvSWQiIElTIE5VTEwgQU5EDQoxNTA2MDc0IElTIE5VTEwgTElNSVQgMTsNCg0KMTUw NjA3NCBJUyBOVUxMIGlzIGFsd2F5cyBmYWxzZSAoZ2VuZXJhdGVkIHF1ZXJ5PykNCg0KKG5ldmVy IGV4ZWN1dGVkIGxpbmVzLCBFUlBfV09SS19PUkRFUl9ERE9fSU5GTyBkb2VzIG5vdCBzZWVtIHRv IGENCnJlZ3VsYXIgdGFibGUsIGhlbmNlIHRoZSBxdWVyeSBwbGFuLCAodGhlcmUgYSBmZXcgaGln aGxpZ2h0aW5nDQp0b29scy9zaXRlcyBmb3IgdGhlIHF1ZXJ5IHBsYW4geW91IGNvdWxkIGFsc28g Y2hlY2spKQ0KDQptdmcsDQpXaW0NCg0KS2VubnkgQmFjaG1hbiBzY2hyZWVmIG9wIHpvIDIxLTA4 LTIwMjIgb20gMTk6MDUgWyswMzAwXToNCj4gSGkgVGVhbSwNCj4gDQo+IEhhdmUgYSBsb3ZlbHkg U3VuZGF5LsKgDQo+IEkgaGF2ZSBhIHByb2JsZW0gd2l0aCBQb3N0Z3JlU1FMIHBlcmZvcm1hbmNl LiBJIGFtIHVzaW5nIFBvc3RncmVTUUwNCj4gMTQuNSBvbiBMaW51eCBwaHlzaWNhbCBzZXJ2ZXIu IE15IHF1ZXJ5IHdhcyB0YWtpbmcgMSBvciAyIHNlY29uZHMNCj4geWVzdGVyZGF5LCBidXQgdG9k YXkgaXQgaXMgdGFraW5nIDUtNiBzZWNvbmRzLiBBbHNvLCBub3RoaW5nIGhhcw0KPiBjaGFuZ2Vk IGluIHRoZSBkYXRhYmFzZS4gQWxzbywgd2hlbiBJIHJ1biB0aGUgcXVlcnkgZm9yIHRoZSBzZWNv bmQNCj4gdGltZSwgdGhlIHF1ZXJ5IHJ1bnMgZm9yIHRoZSBzYW1lIHRpbWUsIHNvIEkgZXhwZWN0 IGl0IHRvIGJlIG1vcmUNCj4gcGVyZm9ybWFudCB0aGUgc2Vjb25kIHRpbWUgYmVjYXVzZSBvZiB0 aGUgY2FjaGUuDQo+ICh0aGUgZGF0YWJhc2UgY2FjaGUgaGl0IHJhdGlvIGlzIDk3LDgpDQo+IA0K PiBMYXN0bHkswqBzb21lIG90aGVyIHF1ZXJpZXMgdGFrZSBtaWxsaXNlY29uZHMgbm9ybWFsbHks IGJ1dCBzb21ldGltZXMNCj4gdGhleSB0YWtlIG1pbnV0ZXMuIEkgZGlkbid0IHVuZGVyc3RhbmQg d2h5IHRoaXMgaXMgaGFwcGVuaW5nLiAoVGhlcmUNCj4gaXMgbm8gbG9jaywgbm8gdGFibGUgYmxv YXRpbmcgYW5kIHVwIHRvIGRhdGUgYW5hbHl6ZSkNCj4gDQo+IA0KPiBJIGFtIGFkZGluZ8KgdGhl IGV4cGxhaW4gYW5hbHl6ZSBvdXRwdXQgYXMgYW4gYXR0YWNobWVudC4NCg0K