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 1wPRbl-000jfw-38 for pgsql-bugs@arkaria.postgresql.org; Tue, 19 May 2026 21:04:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wPRbi-0056l5-1q for pgsql-bugs@arkaria.postgresql.org; Tue, 19 May 2026 21:04:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wPHPd-0049jj-2W for pgsql-bugs@lists.postgresql.org; Tue, 19 May 2026 10:10:58 +0000 Received: from mail-switzerlandnorthazlp170110002.outbound.protection.outlook.com ([2a01:111:f403:c213::2] helo=ZRZP278CU001.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wPHPc-00000000LwO-1e8t for pgsql-bugs@lists.postgresql.org; Tue, 19 May 2026 10:10:58 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=SMLyGl3s0x5uKmrcHxlfhXpI9IQWe+qW3KpZKxbWuyE2J3LuX/oqjoEoRzujNJ+I3e/nBNDnQFGfj56r0pG43c9DVH5hWFejWwQsm3pt0yLMAglpKMva3PNw1OBC8acWVGKwk537sDJeQtY9ebgkUvoPMJxkEzWp+fZpLde+vb79j5+XwkgrkPIS1g3Y2UlrD3HnLInOYb/zm0DN6e0KJS6iplc1PNK/6CqNgfI4G9M/BpHDK2z2aplw25OpdWIZaUEIQ77k4SpJBDpfdv2hR85RUOWxFxuF3deLefiAyC8TGKw5PNc+Ek9HlXcmhBghBY8bWaxVNJN+1tHThHUF1g== 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=1Wga7kAeKTfz5nhZN9MqI9xvYoMh3rinu5Gb7TyhFyU=; b=ObgUSaDZBYydqVoKttb99WS6D7XatLpZ03rio2dlP5qrfWOfCyLQb9LukZTeqK1LnODZbCgnZQhELh5Rzmlq7EgtWQ2iZrmmGx5lnYwsjOGpzA5BZZtKFMC0CLaeThJ+tO0RU2N4z496cXiu/HjgMzLxQGwWsRpJvj9iihSpfAaUEGlAutEm1qdfWFvVrfPs85HOyEffsGU0XEU/vArGTmnt3o8HHh0WFCD1rqtskmLtNAxcSpYcy6c9SGo3fvALS4hgW3JSPgIjxN6TyCOT4ESkdmrXK0rdtgyyRNivvyzrFD+WGiKZqO9v6XjbtMQ8SyWEBcCdupXBlBpZSWtxBA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass (sender ip is 51.103.219.121) smtp.rcpttodomain=anarazel.de smtp.mailfrom=cern.ch; dmarc=pass (p=quarantine sp=none pct=100) action=none header.from=cern.ch; dkim=pass (signature was verified) header.d=cern.ch; arc=none (0) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cern.ch; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=1Wga7kAeKTfz5nhZN9MqI9xvYoMh3rinu5Gb7TyhFyU=; b=RnxzudZe+EGr9tQT2lCjxJ376eJWsi7mzra23ArR07LMju6pmC4kn3OzPkEc39/1OA16gjD/RQQN4+mVdiY5ej3FNFcH+k4KZN8i/KQqLgBkHXpaop5kNJS8KRgLpnhmdXKBEiDbtCrq4TzR7j4fsqCP+CKHhwSo5D/2X6zjKCE= Received: from AS4P190CA0048.EURP190.PROD.OUTLOOK.COM (2603:10a6:20b:656::21) by ZR2P278MB1083.CHEP278.PROD.OUTLOOK.COM (2603:10a6:910:61::11) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.21.25.24; Tue, 19 May 2026 10:10:49 +0000 Received: from AM2PEPF0001C714.eurprd05.prod.outlook.com (2603:10a6:20b:656:cafe::cd) by AS4P190CA0048.outlook.office365.com (2603:10a6:20b:656::21) with Microsoft SMTP Server (version=TLS1_3, cipher=TLS_AES_256_GCM_SHA384) id 15.21.25.24 via Frontend Transport; Tue, 19 May 2026 10:10:48 +0000 X-MS-Exchange-Authentication-Results: spf=pass (sender IP is 51.103.219.121) smtp.mailfrom=cern.ch; dkim=pass (signature was verified) header.d=cern.ch;dmarc=pass action=none header.from=cern.ch; Received-SPF: Pass (protection.outlook.com: domain of cern.ch designates 51.103.219.121 as permitted sender) receiver=protection.outlook.com; client-ip=51.103.219.121; helo=mx1.crn.activeguard.cloud; pr=C Received: from mx1.crn.activeguard.cloud (51.103.219.121) by AM2PEPF0001C714.mail.protection.outlook.com (10.167.16.184) with Microsoft SMTP Server (version=TLS1_3, cipher=TLS_AES_256_GCM_SHA384) id 15.21.48.11 via Frontend Transport; Tue, 19 May 2026 10:10:48 +0000 Authentication-Results-Original: auth.opendkim.xorlab.com; dkim=pass (1024-bit key; unprotected) header.d=cern.ch header.i=@cern.ch header.a=rsa-sha256 header.s=selector1 header.b=RnxzudZe Received: from ZR1P278CU001.outbound.protection.outlook.com (mail-switzerlandnorthazlp17012051.outbound.protection.outlook.com [40.93.85.51]) by mx1.crn.activeguard.cloud (Postfix) with ESMTPS id A299BFC172; Tue, 19 May 2026 12:10:47 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cern.ch; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=1Wga7kAeKTfz5nhZN9MqI9xvYoMh3rinu5Gb7TyhFyU=; b=RnxzudZe+EGr9tQT2lCjxJ376eJWsi7mzra23ArR07LMju6pmC4kn3OzPkEc39/1OA16gjD/RQQN4+mVdiY5ej3FNFcH+k4KZN8i/KQqLgBkHXpaop5kNJS8KRgLpnhmdXKBEiDbtCrq4TzR7j4fsqCP+CKHhwSo5D/2X6zjKCE= Authentication-Results-Original: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=cern.ch; Received: from GV0P278MB1846.CHEP278.PROD.OUTLOOK.COM (2603:10a6:710:6e::20) by ZR2PPF4771B0AEC.CHEP278.PROD.OUTLOOK.COM (2603:10a6:918::2cf) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.21.25.21; Tue, 19 May 2026 10:10:46 +0000 Received: from GV0P278MB1846.CHEP278.PROD.OUTLOOK.COM ([fe80::9e44:b100:363f:ed86]) by GV0P278MB1846.CHEP278.PROD.OUTLOOK.COM ([fe80::9e44:b100:363f:ed86%4]) with mapi id 15.21.0025.023; Tue, 19 May 2026 10:10:46 +0000 Date: Tue, 19 May 2026 12:10:44 +0200 From: =?utf-8?Q?Adrian_M=C3=B6nnich?= Message-ID: <1016198824.20260519121044@cern.ch> To: Tomas Vondra , Andres Freund CC: pgsql-bugs@lists.postgresql.org, Tomas Vondra , Thomas Munro Subject: Re: BUG #19449: Massive performance degradation for complex query on Postgres 16+ (few seconds -> multiple hours) In-Reply-To: <2747373b-d188-43b1-8e49-66f9e23e3c24@vondra.me> References: <19449-4fac687c06cc7def@postgresql.org> <43225458.20260402160627@cern.ch> <94712944.20260402164957@cern.ch> <2747373b-d188-43b1-8e49-66f9e23e3c24@vondra.me> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-ClientProxiedBy: FR0P281CA0100.DEUP281.PROD.OUTLOOK.COM (2603:10a6:d10:a9::6) To GV0P278MB1846.CHEP278.PROD.OUTLOOK.COM (2603:10a6:710:6e::20) MIME-Version: 1.0 X-MS-TrafficTypeDiagnostic: GV0P278MB1846:EE_|ZR2PPF4771B0AEC:EE_|AM2PEPF0001C714:EE_|ZR2P278MB1083:EE_ X-MS-Office365-Filtering-Correlation-Id: 12c08245-efcf-429f-fe6e-08deb58ee652 X-MS-Exchange-SenderADCheck: 1 X-MS-Exchange-AntiSpam-Relay: 0 X-Microsoft-Antispam-Untrusted: BCL:0;ARA:13230040|19092799006|376014|1800799024|366016|786006|11063799006|22082099003|18002099003|56012099003|4143699003; X-Microsoft-Antispam-Message-Info-Original: ciRJgI4zrhm9K0eBGVS/HEDuKglnoRmKCO9KBT21S6RYPY67YMrXOheXzkBN2hOnAKVJePDtAx2DUDnm+/SONuVduI5+q9G1VGxOLChUGaiw8L/+AD67DlirSuX4Pvkrgfrs+rXq20MjupKfCwvZdue72AFWh5jnZQG1isSlPUz2uimC4ra8aAr9uRrwJqS3oufCe82V4ESIro7/3WiiT8FmuoqxuHs8bpQh3EYtB4wO/dmgBpBe96BA1yqPuj+QVSw5pJr0dZWR/NP6aPi1EVqnXni8F5HCqu/XMinMBR1eXzZmA0MGtSJV4Y9DLY8Av6pMskyp0Q4fUNNZQ7oS2SqXQBld4U3JYEH9oIuC+VI/b/tgMJNdBXAF88tR+WgHyy69NFWS47NsUBrKhIeMauRSU1WS45aNUmaIoyQy8yiaDs/Bp2WrOhCIgufJUkpURKg3Tb80TUT3WtgAge6+MJJ1ZvzKZfwuUNErNFASZ5A/FUjv1MOpXOYi/aG4LhuP2EksoLHdx7iCAketRcGNxnWfSZKCfmiiZZ7HoG56JKez3A8ISRtyRWJ74xDaf0PIPHqwLwVEYrmNN+8Yp2V6BKJhcuzRlqBe7UF8RkLypatYjXkNdoH2WPRERUCpVvkDYfwOQQvNw4JoyynJJtDtTWIMGOqZW4DbDnKLAUkwUXtNrZub33+oHifL6CFlNOdF X-Forefront-Antispam-Report-Untrusted: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:GV0P278MB1846.CHEP278.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230040)(19092799006)(376014)(1800799024)(366016)(786006)(11063799006)(22082099003)(18002099003)(56012099003)(4143699003);DIR:OUT;SFP:1101; X-Exchange-RoutingPolicyChecked: NNPJ1hCIeB6BzEv2bniK68fC86BoPeRdsBGUbdKL7RkJcc3LLkxwG4dEzQyj/AjkJZkTvrSV4X92BrwFBvMZOb6SMp+o9UHbiorlMynxOEpF06tFJ2hjo09z3kAfGj7AgB4Ops2MP9EXIyxjV893jmEOrU2d726oJJExxlGIqRWt9Qvr9E93ZtS5U83CxKHmNUuSu9VnhDA34KQRtaf2UlNn1OSQE20izZUf+m0ujMhdo0BInoYwEwsdymdydieVu+LUEKoMBZDoAfH+ifpNcJZMnGvxBo1ZqzELdlQFpU9Wq7Eg3ne9i9kDooWOg+RqNhhKOAz9k+e2w1fGqx0fFw== X-MS-Exchange-Transport-CrossTenantHeadersStamped: ZR2PPF4771B0AEC X-EOPAttributedMessage: 0 X-MS-Exchange-Transport-CrossTenantHeadersStripped: AM2PEPF0001C714.eurprd05.prod.outlook.com X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id-Prvs: e76869b4-1922-4e79-38ef-08deb58ee4a2 X-Microsoft-Antispam: BCL:0;ARA:13230040|786006|1800799024|82310400026|36860700016|14060799003|376014|19092799006|35042699022|11063799006|56012099003|18002099003|22082099003|4143699003; X-Microsoft-Antispam-Message-Info: FVLer6RobC1co7LoMp5ekNCeKcANehoZ/QmTbleSKw66S2LCBfZnYEIR4nNzenWmGNrFBmwheA4fZBLYZ9Ff2q6CfgxLd2j+NTflbNtzTbJYK+AC08t/hXhBZlIHz8m7LNo/S4p2m8flEOWiO/3hNYFEZiIl9+dNwuCDfWnZy2qxhAFGt9hCoiNyJlBcgzb4yN7qbjwIomk8rXGfBM6DSl6rD4AIhAIVdn2hlpd8Jy7LUep+K43YMXi3eo1wEzLcwyTMwJTtmqtKT15yF2E3tw9lDm7XBQ6ULM/dpm4cC3PH5W+U4MAZETUdCLOSoc8mCB4RGqPCnIvJzgsw6tvB0QwKdTDQ2IwoU7m1jW+PbXk8Q5e4b0iFqXPTmXHqXNbc2WFkZdGIOn0OtnzgbZd4iuLZcIV4BojXFFxLcjzHRcL3BLCwrkdAzJTKOqUcraHeonoZyF/xgE8UXTt2JdPzGtOK4Ls2nlpnvhBvF9WaM+OGuY01gprntwJl9yA+KOnBWfVijd1P1fvK9XA7LNiTXiRM60IRvWK02QWduK0JEnqxtHtKkbkVt9WZibUXuJTm+Df8kCSM1haFhYckrw+My4FtnmENH8OJ4nUZXeEN+5tng5Zq/px4caCXMDibxpCAbswrfIDeDuc2+50X3ExWYhfTGaL0N1z4dJupyt+GauVARPf1qc/RdBJxHUi+IpWzfFf/gbB8s/T4IPckDg7vGnB/E81MuR3dC9/XbxwvbBo= X-Forefront-Antispam-Report: CIP:51.103.219.121;CTRY:CH;LANG:en;SCL:1;SRV:;IPV:CAL;SFV:NSPM;H:mx1.crn.activeguard.cloud;PTR:InfoDomainNonexistent;CAT:NONE;SFS:(13230040)(786006)(1800799024)(82310400026)(36860700016)(14060799003)(376014)(19092799006)(35042699022)(11063799006)(56012099003)(18002099003)(22082099003)(4143699003);DIR:OUT;SFP:1101; X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: AE5ZGKnhxXNDGwz7HxxjauZaGzkzlYSwMvolL6cMB9V6wsrec+SfJPR0ypQjMhmuvtTiwV6MbX/njct+thLljab5TORaayQFLneZuhyPvkvghidRICEGz3M4EVTvmgmcPMUK7Um5MSDGoDVJwx5cWhZIhZF8wWM4u/zk7m3xQb7MZ3V+YXQ0Mh1O71nCaa+NyztPBJXFPMajT7ZmFCsmPtCmZ+ayC5lvVsVIi2wreVBcQaq5afvX+zzAZP0okezslGVnn01J8MP6SIl3W2xWPudD6zbKH5A3KQW1/021R4oNvRryEbpukSPHZyB8IIUV8x2G/ZBUoIgDZYZdVUC0EclRrOPq/YOzwUIK9c40kR6+lRbfv5nXzP+Tpod5k9eh2ig4GVvB6DMg1je623cEOr2zIuKH3Mjk9GVrZCoOxNJ61/aUjVfLa6kQuixmLQ9v X-OriginatorOrg: cern.ch X-MS-Exchange-CrossTenant-OriginalArrivalTime: 19 May 2026 10:10:48.6913 (UTC) X-MS-Exchange-CrossTenant-Network-Message-Id: 12c08245-efcf-429f-fe6e-08deb58ee652 X-MS-Exchange-CrossTenant-Id: c80d3499-4a40-4a8c-986e-abce017d6b19 X-MS-Exchange-CrossTenant-OriginalAttributedTenantConnectingIp: TenantId=c80d3499-4a40-4a8c-986e-abce017d6b19;Ip=[51.103.219.121];Helo=[mx1.crn.activeguard.cloud] X-MS-Exchange-CrossTenant-AuthSource: AM2PEPF0001C714.eurprd05.prod.outlook.com X-MS-Exchange-CrossTenant-AuthAs: Anonymous X-MS-Exchange-CrossTenant-FromEntityHeader: HybridOnPrem X-MS-Exchange-Transport-CrossTenantHeadersStamped: ZR2P278MB1083 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, just wondering, when this gets fixed, will the fix only go into the latest master version, or also get backported to other still-supported versions? Cheers, Adrian