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 1wutYJ-000yW5-1K for pgsql-bugs@arkaria.postgresql.org; Fri, 14 Aug 2026 15:10:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wutYF-001JIq-11 for pgsql-bugs@arkaria.postgresql.org; Fri, 14 Aug 2026 15:10:32 +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 1wutYE-001JIh-2d for pgsql-bugs@lists.postgresql.org; Fri, 14 Aug 2026 15:10:32 +0000 Received: from mail-switzerlandnorthazon11012067.outbound.protection.outlook.com ([40.107.168.67] helo=ZR1P278CU001.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 1wutYD-00000000cKe-1IF0 for pgsql-bugs@lists.postgresql.org; Fri, 14 Aug 2026 15:10:30 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=A3Jyld1g26y3xY2A67keIAHHHmiE/JcF5TTV02kW1yMPuK/1V3tHfALYKNS9BJ4v3hIHFunviBIhAnmJ9QKOO57yz6JiBCmUqna48QmZxy3BMmg4RFG3fJPOzqAa1+0ZTx5xiBsnf5RvQWwXAJiJXGuwNY4FDimAYPEJEGmM6FapKzWHeEfAYI2Mes9wA0/r5dt/ikrQdm2gOFTGRzlzjI4niszEWgPwOoK0vJsaggpcTDtqhZe9CSfucP6qYqYCvJNOnQ4bjhpBaoxR56jFIpRmD0oMi2iBj9A1c0/wCJ5AaylVwuM1CSZb/kTLnxVCsQzjNlMzxZq5ujfwIl2T4Q== 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=9Cy2AY2pMs+hYTk2MLucXpjptS8sRhsAwVxpgpuCviA=; b=OcCNl678x2uSaD3XQcy0t4yk3/puII74rBNaHNjpOcOcm1HNi51+lBf0L3HZTSP6pFP0vmuV+puqQ7RjQCen02tbBvVaIJ72WfcSo5+HgJkX9uoKz+7XfPS5LetzkCkckOATRrDj5lgfyVhsMLZ1rNa+1x0frICnj5YrgU15frWHrNMbSV6b70oehOtl6AN8pERyggEW92eoS1g/Q472d36r7tZgYqjF9cHc+h09zfewbSyY2RoIJOTnJEEBmOZrYvHQhrKeat7l74TF6Vc7U8DUkwTRFbnw/tjXclzymSly5L/JmsScQxoAl5KppSXvc/LsGLIqag3m/E7UQMH0LA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass (sender ip is 51.107.2.244) 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=9Cy2AY2pMs+hYTk2MLucXpjptS8sRhsAwVxpgpuCviA=; b=TOOlQW+NP3ltD9QMYEZhZJ9RA+woWeRtG5ihQ3HNXa7IKtX+2vJ3wKatOmPGg1AsEcNnfCOv25blcZIsOxMmzpHrfGy78aTZ9gOSuSlFyNZHaz4sHc/sYUUSv7Lk8qwkDvvTs5fI2Wh1P720PZwf5NXEFUp6XOgMm8dofCVFn5I= Received: from AM0P190CA0001.EURP190.PROD.OUTLOOK.COM (2603:10a6:208:190::11) by ZR2P278MB1052.CHEP278.PROD.OUTLOOK.COM (2603:10a6:910:5e::10) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.21.315.16; Fri, 14 Aug 2026 15:10:24 +0000 Received: from AMS1EPF00000048.eurprd04.prod.outlook.com (2603:10a6:208:190:cafe::71) by AM0P190CA0001.outlook.office365.com (2603:10a6:208:190::11) with Microsoft SMTP Server (version=TLS1_3, cipher=TLS_AES_256_GCM_SHA384) id 15.21.315.15 via Frontend Transport; Fri, 14 Aug 2026 15:10:24 +0000 X-MS-Exchange-Authentication-Results: spf=pass (sender IP is 51.107.2.244) 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.107.2.244 as permitted sender) receiver=protection.outlook.com; client-ip=51.107.2.244; helo=mx2.crn.activeguard.cloud; pr=C Received: from mx2.crn.activeguard.cloud (51.107.2.244) by AMS1EPF00000048.mail.protection.outlook.com (10.167.16.132) with Microsoft SMTP Server (version=TLS1_3, cipher=TLS_AES_256_GCM_SHA384) id 15.21.339.3 via Frontend Transport; Fri, 14 Aug 2026 15:10:23 +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=TOOlQW+N Received: from ZRAP278CU002.outbound.protection.outlook.com (mail-switzerlandnorthazlp17010003.outbound.protection.outlook.com [40.93.85.3]) by mx2.crn.activeguard.cloud (Postfix) with ESMTPS id 6B4927E18B; Fri, 14 Aug 2026 17:10:22 +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=9Cy2AY2pMs+hYTk2MLucXpjptS8sRhsAwVxpgpuCviA=; b=TOOlQW+NP3ltD9QMYEZhZJ9RA+woWeRtG5ihQ3HNXa7IKtX+2vJ3wKatOmPGg1AsEcNnfCOv25blcZIsOxMmzpHrfGy78aTZ9gOSuSlFyNZHaz4sHc/sYUUSv7Lk8qwkDvvTs5fI2Wh1P720PZwf5NXEFUp6XOgMm8dofCVFn5I= 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 ZR5P278MB1853.CHEP278.PROD.OUTLOOK.COM (2603:10a6:910:ad::10) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.21.315.15; Fri, 14 Aug 2026 15:10:21 +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.0315.014; Fri, 14 Aug 2026 15:10:21 +0000 Date: Fri, 14 Aug 2026 17:10:23 +0200 From: =?utf-8?Q?Adrian_M=C3=B6nnich?= Message-ID: <1863016814.20260814171023@cern.ch> To: pgsql-bugs@lists.postgresql.org CC: Tomas Vondra , Andres Freund , Tomas Vondra , Thomas Munro Subject: Re: BUG #19449: Massive performance degradation for complex query on Postgres 16+ (few seconds -> multiple hours) In-Reply-To: <1016198824.20260519121044@cern.ch> References: <19449-4fac687c06cc7def@postgresql.org> <43225458.20260402160627@cern.ch> <94712944.20260402164957@cern.ch> <2747373b-d188-43b1-8e49-66f9e23e3c24@vondra.me> <1016198824.20260519121044@cern.ch> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-ClientProxiedBy: ZR2P278CA0071.CHEP278.PROD.OUTLOOK.COM (2603:10a6:910:52::17) To GV0P278MB1846.CHEP278.PROD.OUTLOOK.COM (2603:10a6:710:6e::20) MIME-Version: 1.0 X-MS-TrafficTypeDiagnostic: GV0P278MB1846:EE_|ZR5P278MB1853:EE_|AMS1EPF00000048:EE_|ZR2P278MB1052:EE_ X-MS-Office365-Filtering-Correlation-Id: c9205864-2129-47c3-cee8-08defa162a23 X-MS-Exchange-SenderADCheck: 1 X-MS-Exchange-AntiSpam-Relay: 0 X-Microsoft-Antispam-Untrusted: BCL:0;ARA:13230040|23010399003|786006|1800799024|366016|19092799006|376014|11063799006|10067099003|56012099006|4143699003|22082099003|18002099003; X-Microsoft-Antispam-Message-Info-Original: K3Y2ABjcDLD24GX1VVjnbePhasx519M9MaMSUx98bwzY+RDTnFaaU2+7ff1mppeafpH6XATeEGzD3hB64chkEACQcC0Vpl/dqz2/hMG9EG8KQ8Ub7X9L/G1JgRmGTMbwRgj4FI+JxQxWnIhVunMblUKf1FTzd/3iYZ/ldk+SPN6pxAeQw1sZqT76WRnKrG6aWHhTST29wvIg7Mh/ciMEcL1/2QwYKSCnvlNSekzTIKWFgbGuRzCd2rk2QF92uEMK4nC6S0N3ct9PHmmou8XLxVQ+uU1fJ36Res/gr+oevAk6ETXS4WUUsxWY/iLC+fdHouW6cd3ey6TWiVkd3yl0ofYpUqREfwt+q10gHf6zR8xe75q1PqXaL0xr3c1TLlgpEhO7N0qzITQAy52CNvVChNl1VglO3H4gTX0vP4vWYMemzRUww7wEWpc3wigEOGGqJfZnscmZCCQ2p9UDaYix6PksnpIST3i2V3aXRPd+xP06Jo/oJQa0Ie9D2OHfWbh5qhLd2aD0u8rD52KxJHwjfgvJFWstyKLp4c+2G2cH0iYcveDiHr9s3FDekHJyB1Fj9ppH5UHA7LDGgOtDLKb5CH4KIMZy9nPds78Q8bZ/8fo6ROdBNKAWlMKn88aT6P3NYN75cMBZckyuFgM3AwoGGSsX9XMRRutJYU3qnyBvv3o= 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)(23010399003)(786006)(1800799024)(366016)(19092799006)(376014)(11063799006)(10067099003)(56012099006)(4143699003)(22082099003)(18002099003);DIR:OUT;SFP:1101; X-Exchange-RoutingPolicyChecked: gxdiUxYLWv5vkW4RE3oqIV/WphXP48laD1c2ybERJ2QQkgqI21jnIMiKgY60eG7f/52k08DBu/CKdOShu3MFGZEGwhQi/5F9weckxKsxz0KEIWswj2rLqG9bPZB81ZTGvNPYOMv7l8qlMH2C0gB2l9t6E6ARZVdzcQGin5MJIts13Imu+GLbvNTTL2HKDuBNZi3DIMcYUuNqNrQe7UKDoQRUIiHQLvRUl8a/RbgHGN3kQL/Ry2shGj++uU00cIGyHayktI6NgrA4jhOhASx0cF+vEbhVtLTAOCiTUXUVuRScw10F+SbUH2hKlIEF9g8/elpPvIj4e9dOI9h8hoiahg== X-MS-Exchange-Transport-CrossTenantHeadersStamped: ZR5P278MB1853 X-EOPAttributedMessage: 0 X-MS-Exchange-Transport-CrossTenantHeadersStripped: AMS1EPF00000048.eurprd04.prod.outlook.com X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id-Prvs: 4a670400-42af-4b40-aa6f-08defa1628a4 X-Microsoft-Antispam: BCL:0;ARA:13230040|82310400026|786006|36860700016|376014|35042699022|1800799024|23010399003|14060799003|19092799006|56012099006|10067099003|11063799006|4143699003|22082099003|18002099003; X-Microsoft-Antispam-Message-Info: fJJhmOFo56SS889Jh406RxK+7grJVnGR0dHIb7jL+241N0fOa6Wy7xP07UqbNKfp6F54ktFa8l4DIreVffF8HhFaGYfQAqcHxRSs/Sx5Fo5Ia7Uz1sVK146HxKRL7ajesGGXNsJIrHMXXBNUk5Dthy1zhDKs8H0UAeBWSEVnxUaG+09oqDGKL00BQD0rlv9x2rRt7BOehZL+qYWWoON9kcMNvqOPsm2sw9AKwXp63gapd59qx3kj47++PT0zw5O+nwhKENPL+hJGg8DK3o/Fvfw9DbEmy0/adid8IfmriamPaglo81RZesSS9C11KJcJNDHLaatGCR2GNdKfzrfVhpDoermK2DZ4XBjnlBvxHv1ADA7HZVtnuLtrp1L2m5XiZKhTXOSL7+0l9OSF06HBbZOBpapHsrpSU+EvwPnoQLbXUs19fwTeKg04+VwIiPm4m0NK/0UwE4biseb91iTLihYu+uSTm6yOVUjx0WGlNGL7IeN6OXqaqfp2g1wQkvLs2yRoJG4W3OhE3QYgIca7W/Ax54y3tkWxdpdnqLoI9yzMGl3WwQtST/R7amSz/2nFStTIjFeDOUf8Es0QOKpMvQ/MEOynAXQJIvo/H82vzzd/TtqZSUaSAv1YLE4NKlSJRVI9AdjjJxNewW6AcYGxYzu/UKteqLexe8gsVcHbqrlmq9tHqAmj5tSxRMS9kSbmMirRuBnNPXlLjkcGS/DVrA== X-Forefront-Antispam-Report: CIP:51.107.2.244;CTRY:CH;LANG:en;SCL:1;SRV:;IPV:CAL;SFV:NSPM;H:mx2.crn.activeguard.cloud;PTR:InfoDomainNonexistent;CAT:NONE;SFS:(13230040)(82310400026)(786006)(36860700016)(376014)(35042699022)(1800799024)(23010399003)(14060799003)(19092799006)(56012099006)(10067099003)(11063799006)(4143699003)(22082099003)(18002099003);DIR:OUT;SFP:1101; X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: s82+rUcl1nRJjIZe5yCVCrSmYT7RVQT8cPrqrohv6AettHQE6tbvH0ItMyWEyvq5oXIcI6ylU13XU1iYWcLLu/18w7vS4oKdA6k2Odb6kPnVRCslL7Y2h3jfuJH6YV57/By6LeUorhm1FSj+YKXz1q15Y4yzZVv7HojrxnTVc6hmLiHbGl43wkjnmw8jrrL5NQwHse2utqEs8VR+XFWDwPElSBfCNRw+HeBWOZRny8uuntf7U+RmyVtcDqmQ0jTjjPUa7CwkWTtPSXg0ifCvoYkMdi1m3/orkqN0LsiRM4we3BmEquGccrxcC6/wX/isu7tEeBeVrgKSw3KUAxRKrSGLY7+LYnaSkoWw+pmfTwiq6/DeN9tfEbZCUOcR645MVXgL52d9AiHfloV7yNKP0B2xiMDEQ/S/CjKoX2Lw5zV36SR9na7NixLXpDfZLO/i X-OriginatorOrg: cern.ch X-MS-Exchange-CrossTenant-OriginalArrivalTime: 14 Aug 2026 15:10:23.5564 (UTC) X-MS-Exchange-CrossTenant-Network-Message-Id: c9205864-2129-47c3-cee8-08defa162a23 X-MS-Exchange-CrossTenant-Id: c80d3499-4a40-4a8c-986e-abce017d6b19 X-MS-Exchange-CrossTenant-OriginalAttributedTenantConnectingIp: TenantId=c80d3499-4a40-4a8c-986e-abce017d6b19;Ip=[51.107.2.244];Helo=[mx2.crn.activeguard.cloud] X-MS-Exchange-CrossTenant-AuthSource: AMS1EPF00000048.eurprd04.prod.outlook.com X-MS-Exchange-CrossTenant-AuthAs: Anonymous X-MS-Exchange-CrossTenant-FromEntityHeader: HybridOnPrem X-MS-Exchange-Transport-CrossTenantHeadersStamped: ZR2P278MB1052 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, ping - any updates on this bug report? Cheers, Adrian > Hi, > just wondering, when this gets fixed, will the fix only go into the lates= t > master version, or also get backported to other still-supported versions? > Cheers, > Adrian