Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wUzXB-001b4p-2Z for pgsql-admin@arkaria.postgresql.org; Thu, 04 Jun 2026 04:18:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wUzXA-004meo-1N for pgsql-admin@arkaria.postgresql.org; Thu, 04 Jun 2026 04:18:20 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wUzX9-004mef-33 for pgsql-admin@lists.postgresql.org; Thu, 04 Jun 2026 04:18:20 +0000 Received: from mail-westus2azlp170100005.outbound.protection.outlook.com ([2a01:111:f403:c005::5] helo=CO1PR03CU002.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wUzX7-000000010zK-3mec for pgsql-admin@lists.postgresql.org; Thu, 04 Jun 2026 04:18:18 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=NOQDtbvF1BqU7ZCm0IoEikvbMCgIODXXdjF+APfC4S5g/48eYNBivkjan5GqD2GDPDyFDjUBwgy6BhLNmL9jGUqwW1c0lypddBE4M6M8zVe60H38SUxxBuTclklr0Cru82iWUg98exifStnUPCUa2dGq4RNgpRUGaeomkP68epHhUuW9AzW5cBmpa1ELSY4DwIv04xo0h2vJDNBY/LCAnQyyXOhs+anWQ7iGENiK2QiO38BacoMCR6UMygQP/EpvRk93kMeZKtyp0+6GjmLobHcajd8i3ZReZjotyo8hi6Ss/qmNfSMW5+7ImfGQArqihR4rP9HlgWDFLNBxHTzWcw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; 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=T4r1hyYH514cml/85X1KmNkkkfMYzSV+2UeXAH2T2K4=; b=QgQ8Uovhb9GmGS231PI6pXb+AnoSoxqQag7F5KdzPinXIp+VOL059mccsxmVJdqIz6f9y77pqsjb4EfTr1jOILXxg6rRDCVBtMM5KI2Iu0rA4L1ubHbq/dkMN3lu8FY4zIIZGX/1V6cPLsXmcgnJwSnlAqPLLG7Uv15g4mq5BInmTAKbDke6g/wMzx9tsXOXgKuKq11YP4+P6OmrUtYgyHGVh/khmkcAyuwiVO9AD4b3VdL7rLSrPoycGWHr3JG0N/XC84RY2X1WB2BWiEgaLrDBFmbkJuu9MW5vsG8w/GRpUAXG8MfSNKgWVSosMNvb2B620hRDBCl35gxt1GjJpQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=elevarq.com; dmarc=pass action=none header.from=elevarq.com; dkim=pass header.d=elevarq.com; arc=none Received: from SJ0PR17MB4320.namprd17.prod.outlook.com (2603:10b6:a03:29b::17) by MN6PR17MB6946.namprd17.prod.outlook.com (2603:10b6:208:470::7) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.21.71.15; Thu, 4 Jun 2026 04:18:13 +0000 Received: from SJ0PR17MB4320.namprd17.prod.outlook.com ([fe80::9bb:9fdc:5b45:28d]) by SJ0PR17MB4320.namprd17.prod.outlook.com ([fe80::9bb:9fdc:5b45:28d%7]) with mapi id 15.21.0092.006; Thu, 4 Jun 2026 04:18:13 +0000 From: Frank Heikens To: Raj CC: Pgsql-admin Subject: Re: Low TPS Thread-Topic: Low TPS Thread-Index: AQHc89hGLZnJVflhvEeOh4kgkIwLYrYtyqBt Date: Thu, 4 Jun 2026 04:18:12 +0000 Message-ID: <1F4B10F9-E3E1-4FC9-AD8F-95B20CC48106@elevarq.com> References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=elevarq.com; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: SJ0PR17MB4320:EE_|MN6PR17MB6946:EE_ x-ms-office365-filtering-correlation-id: cd463b9c-6ba7-4f6b-12af-08dec1f04b79 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|376014|1800799024|366016|38070700021|56012099006|18002099003|22082099003; x-microsoft-antispam-message-info: 3s6Fb/TZfkRt3CSUylA9tLzdR8LhrGX11RInnV67mTHMTiOj8RnKv+wCfCRgx1SkNUkYvvki6qdCeerhIJ7qR0WLBcqznxn1+E+GoXKpca+qA2A6jv1ONRARUSTsoOY/vgY5PB2VVEGXokFdrGjT/EBBstbs/dmXsSbxwdyXCV+kn48VU88nXGT/VmKQExaqqxpAKehA1SRticcRwIljKTFlYretsXcrutidSb6CyPGQfah2Vd2JiNTCRLl0JhIpNBDtSxI3g0saMKuEYyAnKJbXUPJ8mNLdQ1QhTbWJfWbCWJ2GdLZ35I+bwMuHFMkRfj0Ood5zf5yRZq6iHopAhYAD/rrHOQIbMuLf+owDk4Hk1JQtHxkPSqnZHmwTh6J6yvev/K6vV0IFi5EiyYCErOJwAra0a6taAqMyBeSlNFIhXtDydYXRk4blUalpv5N1L+uuU3p/UEvKneRS1I59wWKggOKb+N12Wj/FVThg9aXiovJpmD0m6oS5WNxqpEj6l5/+Z4CtqphQ9mglS9IoEV0/7T2rCs67iHM53TgbVDvtgjDbDpYZp4g26WIZcyZyJ0MELuG0N7L3axHgHwlKv9J1UzBiVMGOGjKN1o3ZvIHZtUz8A1SM4GoW8CooVs/YyPluJsJuam0J372UaEsuWdKV2vy0a708/16HipClr8tgsbZ28hdJjFR7EJ+IDY38ubkXCR6228iB56VM0UANddxKNxTAdo58+mfDETThJvtQseEjy3BjRMATfYmi1sU8 x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:SJ0PR17MB4320.namprd17.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(376014)(1800799024)(366016)(38070700021)(56012099006)(18002099003)(22082099003);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?SWZMbzNSZWo5a3hMTUlkOWFVRkQvaFByc29aaytSMDZaQmRIYjRJeU44Y1JW?= =?utf-8?B?aWxIdWlBWTBJWUVWRUNRZ3haZGNHNkNHZVpwSXhneWE3NHBuMi96b2NneE5s?= =?utf-8?B?TGhtUXJuZlZQY1J5VytXaVZ0L2NLaTRpNm9xRllEbkVNSHZ5SVhMMVRER2h0?= =?utf-8?B?RkhrcFdIK2xQT3E0Y2dMSG12OERXWnV2RzZKWENqNTNYeHA5TTh3L1pvR3pk?= =?utf-8?B?Ky91WG44cWRRNFhDNGJvcmFPMnRMY1RpeStnS3VERG1EV3Nuall6UkozellX?= =?utf-8?B?M2R6NHFITFlRZS9qeXlLWjZ3a3IrdXpXQ0xkZ1FOVzdqSEVTaWRqWG0zMVdN?= =?utf-8?B?VklXcG1na3AwK3pnaFlBNnVLWXJnZXBJbW1RS2tvNlc1RXdXNkRGUjBSS2Np?= =?utf-8?B?cSt3M2N0c2NqUFViRmovTE92Vlc2WEpwR1hRNVdKNlh0U3FmUnUrOFljQlc4?= =?utf-8?B?NEZtUmFaU0Z4T2htN1dTZTgxTDhseE1vQTh4SlNOM3lSQkl4aC9iYmUwaDNY?= =?utf-8?B?NVdHbk1reUQwRlBER1BrWUd1SE5taHJwV1lsTDFkZVRTeldYb1VwUUx1MDRE?= =?utf-8?B?VXByZ20wWjJqYnYrTEtZM2lGTlZHY1B0RFdMTllnOVNwaGJ1MHdzbkpLRjRY?= =?utf-8?B?SGIrUVk2UytVUng2emM2L2Z0dFo5QTJnNTA1Mm11K3Myamx0b20xUVpYYXA5?= =?utf-8?B?SndxWUpLaXpZN0s1dXRUVWFDbDlLZ0pNQ2J3eUpnVkNON0Z5aEVKUzN4T3Bk?= =?utf-8?B?eFVFTlBuTXM3REZjSzdnT2hMQkxIRGlVQXBpQlZmMUo4V0dIbmNjZW15U3hN?= =?utf-8?B?bHpINW1mWWtHMDNRSlordWJ4TFBLTlhkWTRpOEgrNUIzaUFZWkloNEs2ZTZ3?= =?utf-8?B?MG13QmVyK0t5SEhOZzlWeHczeHZSZlZ4dmJYYWRBcXhrUXFzV2g4RUtoYWYv?= =?utf-8?B?TEZtY2YxaEZqNTcyMjgwTVhHdnZwbHVVRi9UN3VDbXdEVUJYb0F4UWp4RU4r?= =?utf-8?B?ZmJxQjEwTHJUUHhrRnFncjRwcUE5bTNqU2V4K0plVHRjKytHTG0wOUhEcTRM?= =?utf-8?B?aXFWMGcwZDRHMzBabkNqS1NyUTlibUhxQ212WXlKYzJWb3lDT0hjL2ljTzJT?= =?utf-8?B?eENRL1NNNVJ0SjVFMHFxWUVPdzJJZDdkRGd1NjN4VEZxcml2N0NCdk1JZFAr?= =?utf-8?B?TzRMdkFGN0pCSUdURXI5Qm9SdXNyMUZNc0pQWnpyTGRpMUkwRXFUTWR6MGI3?= =?utf-8?B?MDhkaytBOWZOK1JnMWtpSjN2ZE9CWEc5NDNNTDMrNVdrUHY4RTEzem1nMEpn?= =?utf-8?B?UTdMT0xOQlkwWmIzb2RsVmRMVTBKc2dtYi9ORlRBS2lDME1UQnVQUDB5OStm?= =?utf-8?B?MjhsYTVyUi91UG9zeHlENGhadW1iS05udjFOQmlBOXphWEE0RHJBbG5xL1hh?= =?utf-8?B?ZnNmbVZBT2d1ckM5V2NDUWlDQWZBK1JhVythaWlNZnhScVh6WFpIS3ZabG4z?= =?utf-8?B?SGdjT2Fjb3g3ZEV2WnZwWnZsZEZuMlZaSEQxOFRTYTI3Q2tVSXVibWtjanA2?= =?utf-8?B?VlRXeVZsY3FLVWx6dm5nbStkd0NvcjNsMjhIVjdYV0RYeUx4ZDMxL3Q1QzlE?= =?utf-8?B?Ry9NNlpFL2p5RXpXOXR6eUpCd3N5dnJNUHZXMnIrS2hyakk2NTJISUJFcWJR?= =?utf-8?B?UzZhL08xY0x2b2FzMk1CQzE2R1pjcGo0MzE3bHdCK0ZvMFZsOFNLMjRSOGVG?= =?utf-8?B?Q1MvTHpIcklocVRYS2g1NWgvSHFWUHcwU2hjaHZTdFphcmN2VzYrdlJ2UE9v?= =?utf-8?B?aDY3ZU1JU1NySUtUeUo4aWhzQmJaemo2RFY5bFVFQ1l0djFDdUhvb1NiemVZ?= =?utf-8?B?Vy9rclFyRE1QOFJET1U5WlFNOVo3N0Qzc2Zkc0lQY1NRYTlmRERIMThiZ0Fi?= =?utf-8?B?ZlZGWFl4VkM0S2tNZWRpZWxOeUU3dVRoaEZRaDZQUVo0SEF0MTd1aE1jZUJn?= =?utf-8?B?bnl4dXBCZVcwMGlNTEZpREQ5L0Z1YUxFNitlSlBKeXRySUdsV2tvYmZVNk00?= =?utf-8?B?STJrK21WTUZyakh5eDRUS2xUaTh0SndJWEd4ZWZHZUJtZ09FSi90bDJvSVhN?= =?utf-8?B?MklVWVJPL09SdXVPZnlwbUt5TDFuclpmblhlT3hCNEVBQXpZTFFjNnpvbldH?= =?utf-8?B?VEJsU0YvWjdWc0FXSDZ3Q1B1S1hzdlF6SVRvVEl0OVN0Wm9mS2M5RFQ2am5X?= =?utf-8?B?RjJiNnV6QzJDcVl5azdMaG83TEorTS9oWTUyTmRKT0tiY0FORmJ0R3BUM2ZU?= =?utf-8?Q?o2Ps+IlyaWUg7lFl+T?= Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: elevarq.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: SJ0PR17MB4320.namprd17.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: cd463b9c-6ba7-4f6b-12af-08dec1f04b79 X-MS-Exchange-CrossTenant-originalarrivaltime: 04 Jun 2026 04:18:12.9105 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 9348e2a6-fdef-4896-b245-954683513408 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: NpKstQJ5HLMP1Y3e8YO4bGt1B/w2nALKXy7RhiDKBJj2T7Gd0sZ+8nw6WwYp64Cl2I0C3qo7eiMcRfJzvXm5OA== X-MS-Exchange-Transport-CrossTenantHeadersStamped: MN6PR17MB6946 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGksDQoNCkF0IHRoZSBtb21lbnQgdGhlcmUgaXNu4oCZdCBlbm91Z2ggaW5mb3JtYXRpb24gdG8g ZGV0ZXJtaW5lIHdoZXRoZXIgUG9zdGdyZVNRTCBpcyB0aGUgYm90dGxlbmVjay4NCg0KQSB0aHJv dWdocHV0IG9mIDYwIFRQUyBieSBpdHNlbGYgZG9lcyBub3QgdGVsbCB1cyBtdWNoLiBUaGUgbGlt aXRhdGlvbiBjb3VsZCBiZSBpbiB0aGUgYXBwbGljYXRpb24sIGNvbm5lY3Rpb24gcG9vbCwgbmV0 d29yaywgZGF0YWJhc2UsIHN0b3JhZ2Ugc3Vic3lzdGVtLCBleHRlcm5hbCBzZXJ2aWNlcywgb3Ig ZXZlbiB0aGUgbG9hZCB0ZXN0IHNldHVwIGl0c2VsZi4NCg0KQ291bGQgeW91IHByb3ZpZGUgc29t ZSBhZGRpdGlvbmFsIGluZm9ybWF0aW9uPw0KDQoqIFBvc3RncmVTUUwgdmVyc2lvbg0KKiBEZXBs b3ltZW50IHR5cGUgKGJhcmUgbWV0YWwsIFZNLCBBV1MgUkRTLCBBenVyZSwgZXRjLikNCiogTnVt YmVyIG9mIGFwcGxpY2F0aW9uIGluc3RhbmNlcw0KKiBDb25uZWN0aW9uIHBvb2wgYmVpbmcgdXNl ZCAoUGdCb3VuY2VyLCBIaWthcmlDUCwgZXRjLikNCiogQXZlcmFnZSByZXNwb25zZSB0aW1lIGR1 cmluZyB0aGUgdGVzdA0KKiBOdW1iZXIgb2YgYWN0aXZlIGRhdGFiYXNlIGNvbm5lY3Rpb25zDQoq IENQVSwgbWVtb3J5LCBhbmQgZGlzayB1dGlsaXphdGlvbiBkdXJpbmcgdGhlIHRlc3QNCiogVG9w IHF1ZXJpZXMgZnJvbSBwZ19zdGF0X3N0YXRlbWVudHMNCiogV2FpdCBldmVudHMgb2JzZXJ2ZWQg ZHVyaW5nIHRoZSB0ZXN0DQoqIFdoZXRoZXIgdGhlIHdvcmtsb2FkIGlzIHJlYWQtaGVhdnksIHdy aXRlLWhlYXZ5LCBvciBtaXhlZA0KDQpGcm9tIHRoZSBkYXRhYmFzZSBzaWRlLCBJIHdvdWxkIG1v bml0b3IgYXQgbGVhc3Q6DQoNCiogQ1BVIHV0aWxpemF0aW9uDQoqIE1lbW9yeSB1dGlsaXphdGlv bg0KKiBJL08gdGhyb3VnaHB1dCBhbmQgbGF0ZW5jeQ0KKiBBY3RpdmUgc2Vzc2lvbnMgKHBnX3N0 YXRfYWN0aXZpdHkpDQoqIFdhaXQgZXZlbnRzDQoqIFRyYW5zYWN0aW9ucyBwZXIgc2Vjb25kDQoq IENhY2hlIGhpdCByYXRpbw0KKiBDaGVja3BvaW50IGFjdGl2aXR5DQoqIFdBTCBnZW5lcmF0aW9u IHJhdGUNCiogUXVlcnkgZXhlY3V0aW9uIHRpbWVzIChwZ19zdGF0X3N0YXRlbWVudHMpDQoqIExv Y2sgY29udGVudGlvbg0KKiBSZXBsaWNhdGlvbiBsYWcgKGlmIGFwcGxpY2FibGUpDQoNCldpdGhv dXQgdGhlc2UgbWV0cmljcywgaXQgaXMgaW1wb3NzaWJsZSB0byBkZXRlcm1pbmUgd2hldGhlciBQ b3N0Z3JlU1FMIGlzIGFjdHVhbGx5IGxpbWl0aW5nIHRocm91Z2hwdXQgb3Igd2hldGhlciB0aGUg Ym90dGxlbmVjayBpcyBlbHNld2hlcmUuDQoNCkNvdWxkIHlvdSBzaGFyZSB0aGUgYWJvdmUgaW5m b3JtYXRpb24gYW5kIHNvbWUgbW9uaXRvcmluZyBncmFwaHMgZnJvbSB0aGUgbG9hZCB0ZXN0Pw0K DQpGcmFuaw0KDQoNCg0KPiBPbiBKdW4gMywgMjAyNiwgYXQgOToxMeKAr1BNLCBSYWogPHJhamVz aGt1bWFyLmRiYTA5QGdtYWlsLmNvbT4gd3JvdGU6DQo+IA0KPiDvu78NCj4gSGkgYWxsLA0KPiAN Cj4gSWYgdGhlIGFwcGxpY2F0aW9uIHRlYW1zIHRoZXkgYXJlIGFibGUgYWNoaXZlIG9ubHkgNjBU UFMgYW5kIHRoaXMgaXMgbm90IGV4cGVjdGVkLiBUaGV5IGFyZSBjYWxjdWxhdGluZyBiYXNlZCBv biB0b3RhbCBzdcOnY2VzcyByZXF1ZXN0cy9taW51dGVzIHdlIHJhbiBsb2FkIHRlc3QqNjAuDQo+ IA0KPiBGcm9tIERhdGFiYXNlIHNpZGUgd2hhdCB3ZSBjYW4gZG8gYW5kIGR1cmluZy5sb2FkIHRl c3Qgd2hhdCBhcmUgYWxsLnRoZSBtZXRyaWMgd2UgbmVlZCB0byBtb25pdG9yIGZyb20gb3VyIHNp ZGUuIFZjcHUgMzIsIDEyOEdCIFJBTQ0K