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.94.2) (envelope-from ) id 1v27b4-000VVY-3a for pgsql-bugs@arkaria.postgresql.org; Fri, 26 Sep 2025 12:30:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1v27b2-001Aht-2i for pgsql-bugs@arkaria.postgresql.org; Fri, 26 Sep 2025 12:30:44 +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.94.2) (envelope-from ) id 1v27b1-001Ahk-KL for pgsql-bugs@lists.postgresql.org; Fri, 26 Sep 2025 12:30:44 +0000 Received: from mail-centralusazlp170100005.outbound.protection.outlook.com ([2a01:111:f403:c111::5] helo=DM1PR04CU001.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1v27az-0001X2-2T for pgsql-bugs@lists.postgresql.org; Fri, 26 Sep 2025 12:30:43 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=L9zMuv0T6UWdkDat4htffWlZGwVpRpTWca7VfjJdRkwY7vhh2N97ZUepzNeqTAay2s4CrI1v63Tq2mBhu7Ee0u0Tt0yS8up08/y+JzlMlDiKxoh9JqNQgbd80eMcNg8pgKASgtIB8gJRFLfsb1QV45jyjd+zu3tIwFHaIZ/LzPYzcogDSpLwbPpPJX9Opi3WbcvRnf1ZKIUrfr81eele/5WQzeTly/6j7bGAsXV3LhAOcy5UrfwgJ2a0SCBoksINH3OTImmCU2a1vRuyfSeUIXxWKmQXNJy6KMkKnsnF3ZKMO2rMzqNg/PCgfyLuCBWHGwTRYzY/zVM3pf7zZGl4LQ== 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=3MOOwmoneMqPKS+PlCEzsnhciXvCd4wCC3CAProWMAQ=; b=ebsZ15g/MO45a4YVZCK9EpAVWDkWjFzriv7AYHz/n7/eIHZg60qqB+C1PlS+YFzQgkJA4vjyb3ouvCQhDYjATOXW0m0qHDPR+u+55P3VcwdLbIezcbsRkIFmtsYuAG4nPUT8FncGNTblWLE7/ZXcjnQP4Pdc7S1OnPhdMbTPkPCsT/1w4szUtH63LqMaSPagD85tdPu57n/ismhCIg3fjYLVYrve/rq2WLXtAKAid1io+S+YflZcwhRHPE7j87n8jm1GWIbV+cZQqwuZeWdaVnlPfOLxOjrA7g7IsRsjUnT9mHKdh2sWPVxCQOb+XZSCsxmbzdNZJqJDLC6Z+BOzTg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=blackduck.com; dmarc=pass action=none header.from=blackduck.com; dkim=pass header.d=blackduck.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=blackduck.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=3MOOwmoneMqPKS+PlCEzsnhciXvCd4wCC3CAProWMAQ=; b=p1b3JsAn93ibRTbXig0537t7G5JSmSiYj5GvE+aNHyP2P1Sl7JpGzRGihAwSVdxFZMOJkk+oCa85iPiV4NkiaM79KBrXLl8FQxjhD77IAiIsiuOIQOxDP1XrGDGoAX5CIN4uC1qcnfAjeIKo2487AzPgvJR0yXcRg/ZOpxB4MmQVTxoXjivIWy/yXmtV2jVSKZ5KQZvoYngSG8qCV8SJJbUWdSYK5DgVqMfGplXsqw4j/PFQNje2aocMeGujvAqqYjkTiUN6AReKK7I4c0jVWQtgaZUWL0lEj+ZCZHQZrOHxhSTezS62ySRo89f+8LwZ80lDZmv+YJ/34lRKxyOjuA== Received: from BY1PR19MB7749.namprd19.prod.outlook.com (2603:10b6:a03:533::10) by IA0PPF93D3B5114.namprd19.prod.outlook.com (2603:10b6:20f:fc04::cb8) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9137.13; Fri, 26 Sep 2025 12:30:36 +0000 Received: from BY1PR19MB7749.namprd19.prod.outlook.com ([fe80::92e8:adc8:dff0:f918]) by BY1PR19MB7749.namprd19.prod.outlook.com ([fe80::92e8:adc8:dff0:f918%5]) with mapi id 15.20.9160.011; Fri, 26 Sep 2025 12:30:36 +0000 From: Todd Cook To: Peter Geoghegan CC: Merlin Moncure , Tom Lane , Sajith Prabhakar Shetty , Andrei Lepikhov , "pgsql-bugs@lists.postgresql.org" Subject: Re: Postgres: Queries are too slow after upgrading to PG17 from PG15 Thread-Topic: Postgres: Queries are too slow after upgrading to PG17 from PG15 Thread-Index: AQHbxVqT0ETTgYC/QU6QMIBlaKuz/LPTwAwAgGK0SzqAAFlJgIAAC4nVgAAChACAEKVOAoAA9GCAgACWuNCAAnYuAIABpTKAgAALLYCAAAXwAIAABEyAgAGUJoCAADidgIAAD2kAgARUOYCABE6lAIACGg0AgBnUZwCAMRZOAIAATdKA///I7QCAAEghAIAA1WoA Date: Fri, 26 Sep 2025 12:30:36 +0000 Message-ID: References: <2a8243eb-a8e8-4c2d-9c46-7152782d84f8@gmail.com> <2121299.1753993453@sss.pgh.pa.us> <2128451.1753997128@sss.pgh.pa.us> <2532876.1754096999@sss.pgh.pa.us> <2538941.1754100308@sss.pgh.pa.us> <53859E8F-67E7-4A25-AEE1-C7E472262F47@blackduck.com> <2CB274CF-6282-48F9-988F-59F16E1D0EEC@blackduck.com> 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=blackduck.com; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: BY1PR19MB7749:EE_|IA0PPF93D3B5114:EE_ x-ms-office365-filtering-correlation-id: 7eaa81bc-9c66-4736-3389-08ddfcf87ec5 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|1800799024|376014|366016|38070700021; x-microsoft-antispam-message-info: =?utf-8?B?L05mU3BmTEtJaTUwL1NjdWJ4V0p3UDQ0c1ZDY2dyb3VNeUdzRnpWL2crVVcz?= =?utf-8?B?V0tHcHhkeGkvU2IyY1BqNHFST0Zac0wxbXdjY0wyUFFPZmJ0UUxnMldrOVI0?= =?utf-8?B?VkpQS3VkeHNkSjBZSVJoaS81MUdGbE9SS09pcWREZ0ZoUzNPWnRyai9BWE1x?= =?utf-8?B?ZUhCbGk0b0xTUlJ1Z29lUStqTE4vcE0wWHp1Zk5vVW4ycmVQUG5HV2tQOWNU?= =?utf-8?B?Sy8vRFd0NUZ5SlhPMGdIKytrb3BYTXlFbTJQYjNBaVIrNEdzNkZpdmlPQmdF?= =?utf-8?B?NWJmaitWSnMzYkVpNldvaU40QUxFM3RUaUlwYnBJdGx6N2UxcC8wVmFQY0Zy?= =?utf-8?B?djVqSU16SE5IZFhoWDE1dy9BaHdDVUpEZnVTblpYRHVDcm52NCtxR2VLdmo5?= =?utf-8?B?TU9NcXpSK0xkRFRTc3NLMWtUU3c4T25BZGpuWkdMOU5zbWVoZ0k4cGJNUzhO?= =?utf-8?B?NlNDczFqN2c4WU8wN3NJcEhpWVYxMVZsOTI1UHV2eFJXT25vV2ovWlVBMnFt?= =?utf-8?B?cFVMdDhNSzJLZ2JaZEp6aGxLRUtJU0VZdkdsc2dreExIUlk4cmZ1SG5XYkx3?= =?utf-8?B?ZWRJS3pzRjZHYXFNTlZUOWhxYit5dHQ5OVJlZGpKUzViQi9PMUkzOWQ4MGdL?= =?utf-8?B?b01EdnNqa0drWEErdlIxRlZ2eFhsSjRBRGJmNmVuTmFTTjBMVWJ1TU5NV0po?= =?utf-8?B?WFJvTlBSWjdsdDk0T05jZFl3QjFOOVp0T0p2UjMwb3ZVb3NlSlFlR0FLOVpm?= =?utf-8?B?ZjFKRXRHTmt6bUtWZXhOQ0Q3UmJ2VnFqcUxhV3ZmM3Vic2dPUzg0aXRhSS85?= =?utf-8?B?cmpxeDdxYVJPQldLeGRkMUd5T2xtcHlVdTcxOEJ6YzNCZS9LNXVIS1d3NlBS?= =?utf-8?B?N2RReGtkU1pOM1pvS1JyY1luQkRiTHRDektiM0NHaDBTZHJURGsxZFhLSjgy?= =?utf-8?B?Yi80c1ZjcEtjUVkrOE9OY2cvM0FJZzlQc2hCMWE2cnByYXZYaUc2MC9OZGJz?= =?utf-8?B?VXppS3kzaGZuMjdZQ0diSmZ2WnVSWFhlQjlLVlg2N1pJcHp2dXlGSUxmakMx?= =?utf-8?B?eGtMVW5ENXJPTUVuekVueWlmN1hzdkhRMm9LVzl0ck55d0RWZmsyYTA3WnV0?= =?utf-8?B?Nkc4MUdsRWhYYkdXVGk3YnYvVVU5TGdXSUU4VjFCaFVyMjdhY0N5OERRQzRz?= =?utf-8?B?Y01zeXhzWmJsalRSakJUY3Iyd1NlS3lSV2pTMmVpclZqMi9sVGhlNjgybGF3?= =?utf-8?B?U2kwSWtZSXdyWk0rSTI5Z3A4RnJsK3ZMaXM3RmllZlYrdmI1TXZGaUxpYjV3?= =?utf-8?B?ZE5vcnJkQndjSmFDY0ErNEVUNTczaThYNEMrV1RvOXZBUlQrVkhobHQ2dWx3?= =?utf-8?B?Yms2L1Y2UjFldXkzRHhvbkQ3UFFTYmNCMUgwTjdPOVlzTTg2TmE2Nk5JMm90?= =?utf-8?B?N3paSzF4VWdqNHlaemFvTnMvTlIrMXlQdHBvM29JY0t3eE1HVWF2UjhJZEhB?= =?utf-8?B?MmlndEVqZzRSbjIxUEJlWi8wVk5ETkxLV0hGZ2l4KzBLUUxHTHJHUzZveDZK?= =?utf-8?B?VjJJMWhIcWR3ZW9GaXRtNkJsRmZlK2FyellMSmdpUTArNzE1dXpicHFjZ1Bh?= =?utf-8?B?dkFVd1JkcGF6NE9zNnd0UzRmRTMzZTlncUlYVDlsdmI5cU9mb0RtMTRWSysw?= =?utf-8?B?S0JkK1E0alFjTnVvZ2VCeVpxKy9jTzZNME1jSG96TGJhWkN0NEsySVprWHlT?= =?utf-8?B?TlBkZUFLS081Q3lwWWhTUEJwa3RPbTNXRTVTeXljS3VDazNKdFAwM21yL0gr?= =?utf-8?B?OGREa0tsSTBSb0dseVdsM1UwV0w4ZUs5V21yMUlXallDaWZLU2R1Mkg4ZVor?= =?utf-8?B?SGNjQmxUTjlVaWFBbWpVZmxJY3RRcU5lem53eE1obE1GRS92YUtQZjE0bVlz?= =?utf-8?B?aEF0VktNVURVaUsrazRFQ3hVRGtLMkwvbTRIaW5RVFRuUzRFNzZTL0tmQWhu?= =?utf-8?B?d00za3pEamlxREFmRjI5RkZSd3FzdVZFWk10Q0xoVVdZUWFYVlVxeWIwM1gy?= =?utf-8?Q?bZEDcY?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:BY1PR19MB7749.namprd19.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(1800799024)(376014)(366016)(38070700021);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?Mk5JTDhrVk5lalVSM2FJYWVGdFdSY295NVNJekw2azNjRUhZc2MrbmIxMlIz?= =?utf-8?B?VzlCZjVyN2lhSzdyM0x4SG05blhUZEdCTExPRXAydXZhbDRUVi95UDg3RXpK?= =?utf-8?B?ZmtBbFJQK2VqTHBaZ0ZrRUczVjV1Qm5QaVZyYlM3SnFXMFJHWWpKTlJ5UTJR?= =?utf-8?B?SFIzMm1DVElaU1V2MURsWG9TLzBHM3oyeG1YVW44MTRTWTFtWUdpT3lnL25I?= =?utf-8?B?S1dDalRCOVQ4anFIdXdTM04wbVlBQmhndjRCNGFRN01rYkdPZWtOd256MVlI?= =?utf-8?B?SHV4ZDJMa0swUmFQaGt2RDRXYkRUK1VwMFljUHV1NzNoaE9RRFZlbTZma2VK?= =?utf-8?B?emh5c3hHSkIxdGY1R0NQOTVRLzhtMEc5WEZCNEFVQjJ5ZU0zZVkxSndJYk1w?= =?utf-8?B?bjRwakF0b1BhTE5UUWZJNVU4ZCtYSS9XUGFzQXR1bUwrU011ckZiWURtV2JX?= =?utf-8?B?ME1ZRXAzNElDcWkrZUdjNk1xcHlCRFhJWStPMFNYNDZ2L2lSdUVNckpVdG9o?= =?utf-8?B?em5qWXp6RmVyYWNlK2ZDMHlselBTcG9OL0R2ZktWbXZ4aUVja2NXYjFEamxP?= =?utf-8?B?MERhcDFLaWhrMzdyNmw1R3ZqMWVCMWc3NytUTHBPU2NvN0NjWVhBVUlIYUh3?= =?utf-8?B?SEhiQzRYcW02eWxPZlgzV3R3Vko0MVJadlByMmRaTytCeXJhbE9PcDZKNGM2?= =?utf-8?B?elRHdlpTTExjQ0hsSmRjKzFZZE40U3V0cTlJQnZremcrSkhaaVR4WnAyUUdq?= =?utf-8?B?VWlxVXZoeGNQTnVwbHNvamxKdWl0bVJYZUh5WDU2Y3BrUmtGM29aRTVpeTRX?= =?utf-8?B?UHdqMDJHWTBkbVJSNVFTSjFNR3d0UDNCSGMzRTJFUDMzUVBLMXZ1SjdlVEtY?= =?utf-8?B?WFJjMmZmZFhZREI3VXd2NytjMjV3cjBicWIxcE5PYmtrMFY3YjR0T2hUL2Vo?= =?utf-8?B?YUR0WG1FUUxyanp0bHlzaEhsb1lWUmd3MFEyeDF2c2JDK3YrM1o0a1RNUlNO?= =?utf-8?B?VEJoRjlPN2lhMnBiK2JKaG5TZk9hMW5pWFNYbDdrZzdnUU1QQ3YxYTF5T1Fu?= =?utf-8?B?Q2JOQmNoNVl6RWROWERPbWFIN1B4cU9SRkFjWUc5SGNNeDNhTDVrSHJ2RGRL?= =?utf-8?B?dVNTNGNQWDBINE9MSTVIRGt3RElXcno1UEFac1VGRnQ3YW1tK0RiTkRGTGRq?= =?utf-8?B?cm0vMWJjWnJ4T0U1ZFJWcWZSQ3QxTXA5bW5LdUIzd1dZK0RnYlZQckh3V09a?= =?utf-8?B?Q0FLeGNibzVyUkpMaXl5amdMZTZsYnhCTTBPWElkTTN3Z1NnR0RYdTNCKysw?= =?utf-8?B?Z2lPUW1oU0hXa21PdGdaNExqSzY1eTdyQXo1QktkNHRpUEtudWt2QXZZclM1?= =?utf-8?B?UlNqb0I3N0h6R3dhb2QvSXlDZmF6cDFtam1IN0NXL0FUM0N4d2Y1Q3VLdm5P?= =?utf-8?B?bklwOWlRaHJBVWptQXBxcTVZbU0zN0w0MTIwMzljNGd6bDEydnlLK21ydWxC?= =?utf-8?B?ZXBRVjd2WTllcWpoRmhyLy9TbHhtdWpCaXMxVCt4M2R0NkozOE92bnUwMEEv?= =?utf-8?B?aWRrRE8wRXJqQVlVZFBqZlRyUzZFV0taRXVLbGVVbWRqUUZGNVlxOUZmQm5K?= =?utf-8?B?dEMwMXhPcUpCcldxTUF2cEp4UnZZTVRZTy9oV0pUM1UzZlRVZDhVSGdoUWpn?= =?utf-8?B?S2JMaEsrUXJPMFAvYmpqaTNwLzhGc20rTXBZZGQ1RjBMOFNWWG1wTEZLaEZy?= =?utf-8?B?MlFzWEw0b0YvZlBxejBMdFVJeExNWmx4akUyNTZmREpwRUtrcllFSFpTTGpj?= =?utf-8?B?ZFRLVmJGOWZ3cVJLNGtKYTF3RUhZMXlwbW8zZ2dTelAzUmVycTd2bVhycTU0?= =?utf-8?B?RHRtcWh6TzdDN2VUa2k2QmpCaGZyelBYWEFBVXpDTkFpTVplaU5sT004cC9T?= =?utf-8?B?Rm4vQk42bStyTy9ieXNXT1hIdXpyczQxZTN2MEQ0SkVIZjRBUkpRSm1iYnV6?= =?utf-8?B?cEN6em9NeXFLUksyVUt0bktscTlsTHM0bGNzby9HbFhmNXRXZGFRQ05nZzBh?= =?utf-8?B?MFAyWHRiNEFnODFUYUdYU3R1TUtNQWZoYU9JV3pYeXVCZTNYd05CMmtkQXIz?= =?utf-8?Q?K0XV/hinRSbrZ5uJohEYDk05v?= Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: blackduck.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: BY1PR19MB7749.namprd19.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 7eaa81bc-9c66-4736-3389-08ddfcf87ec5 X-MS-Exchange-CrossTenant-originalarrivaltime: 26 Sep 2025 12:30:36.5289 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: e709ae1c-ef4f-432d-a263-a39c33d2c5c1 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: BvqJR9UDuK7IYKArUXTG8NXV9iPcvRzh2ncV+sY6FVLXGXiWBoaM/hoeEevR1XhoVT7n4NXgGkrrW+djcbs2cw== X-MS-Exchange-Transport-CrossTenantHeadersStamped: IA0PPF93D3B5114 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gOS8yNS8yNSwgMzo0NyBQTSwgIlBldGVyIEdlb2doZWdhbiIgPHBnQGJvd3QuaWUgPG1haWx0 bzpwZ0Bib3d0LmllPj4gd3JvdGU6DQo+IFNob3VsZCBiZSBub3RlZCB0aGF0IHRoZSByZWdyZXNz aW9uIGl0c2VsZiBpcyBkZWZpbml0ZWx5ICJhIHNtYWxsDQo+IGVmZmVjdCB0aGF0IGlzIG11bHRp cGxpZWQgYnkgcmVwZXRpdGlvbiIuIFRoaXMgbWFrZXMgdGhlIHByb2JsZW0NCj4gcmF0aGVyIHBl cnZlcnNlICh0aG91Z2ggaXQncyBub3QgZXhhY3RseSB1bnVzdWFsIGZvciBhIGNvbXBsYWludCBh Ym91dA0KPiBhIHBsYW5uZXIgcmVncmVzc2lvbiB0byBiZSBwZXJ2ZXJzZSwgaW4gb25lIHdheSBv ciBhbm90aGVyKS4NCg0KVGhhbmtzIGZvciBjb25maXJtaW5nLiAgV2UgY2FuIGRldmVsb3AgYSBz dHJhdGVneSBmb3Igd29ya2luZyBhcm91bmQNCnRoaXMgZWZmZWN0LCBzbyBmcm9tIG15IHBvaW50 IG9mIHZpZXcsIHdlIGNhbiBjb25zaWRlciB0aGlzIG1hdHRlcg0KcmVzb2x2ZWQuICBJJ20gZ3Vl c3NpbmcgdGhhdCB5b3UgZmVlbCB0aGUgc2FtZSB3YXksIGJ1dCBpZiBub3QsIEknbQ0KaGFwcHkg dG8gaGVscCBvdXQgaW4gYW55IHdheSBJIGNhbi4NCg0KSW4gYW55IGNhc2UsIEkgZG8gYXBwcmVj aWF0ZSB5b3VyIGVmZm9ydHMgYW5kIHRoZSB0aW1lIHlvdSB0b29rIHRvDQp3cml0ZSBvdXQgdGhl IHZlcnkgaGVscGZ1bCBleHBsYW5hdGlvbnMgeW91IHByb3ZpZGVkLiBfXw0KDQotLSB0b2RkDQoN Cg==