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 1vI7Im-00Dxyd-26 for pgsql-bugs@arkaria.postgresql.org; Sun, 09 Nov 2025 15:26:00 +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 1vI7Ik-006yGL-QV for pgsql-bugs@arkaria.postgresql.org; Sun, 09 Nov 2025 15:25:58 +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.94.2) (envelope-from ) id 1vI5q2-006Les-UW for pgsql-bugs@lists.postgresql.org; Sun, 09 Nov 2025 13:52:15 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vI5pz-006oZJ-2D for pgsql-bugs@lists.postgresql.org; Sun, 09 Nov 2025 13:52:14 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=BoddwQ6OsqQEhRajhyksu+RrZf+Gk7TRvCQrVX27mTM=; b=QN9BS+DGmnR4c8ZuZS3VQFuDWF /4iUS53nM1d8y8BMKa7pgNaY7IK2Hc1G0HLGQwciEPlOAZtDxTwTevsvxnaBDigUIjiCNPp1AZPWH z4ExJyzH3k6QMAKRHs9OuGAvntjP7yLAY8JAhpbYYn4RZfVRNZsOyyHDtV8p7DmBkl5FtH2X4/24Y hIa2rBaRGJCQGYAaM5ggCA5MmaNIZ4lnBqXyaxGJToB37V6XJiGy2Y8ReQvZxf44OD5iZQ/WxSfwh wH6Z+psLuJHi3VIQUC2jclVLFqcIZgxvlwAvp+2q1cnysDVP4CQRu/rPlBMjDLmht+6YHGa1+PM/b pjti/8uQ==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vI5px-00C7lO-RL for pgsql-bugs@lists.postgresql.org; Sun, 09 Nov 2025 13:52:09 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vI5pq-0026QC-2T for pgsql-bugs@lists.postgresql.org; Sun, 09 Nov 2025 13:52:03 +0000 Content-Type: multipart/mixed; boundary="===============2542117657721242238==" MIME-Version: 1.0 Subject: BUG #19106: Potential regression with CTE materialization planning in Postgres 18 To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: kamil@monicz.dev Reply-To: kamil@monicz.dev, pgsql-bugs@lists.postgresql.org Date: Sun, 09 Nov 2025 13:52:01 +0000 Message-ID: <19106-9dd3668a0734cd72@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2542117657721242238== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTEwNgpMb2dnZWQgYnk6ICAgICAgICAgIEthbWlsIE1vbmljegpFbWFp bCBhZGRyZXNzOiAgICAgIGthbWlsQG1vbmljei5kZXYKUG9zdGdyZVNRTCB2ZXJzaW9uOiAxOC4w Ck9wZXJhdGluZyBzeXN0ZW06ICAgTml4T1MgdW5zdGFibGUgZmZjZGNmOTlkNjVjNjE5NTZkODgy ZGYyNDlhOWJlNTNlNTkKRGVzY3JpcHRpb246ICAgICAgICAKCkFmdGVyIHVwZ3JhZGluZyBmcm9t IFBvc3RncmVzIDE3IHRvIDE4LCBvbmUgb2YgbXkgcXVlcmllcyBzdGFydGVkIHJhaXNpbmcgYW4K ZXJyb3I6CiJ1bmV4cGVjdGVkIG91dGVyIHJlZmVyZW5jZSBpbiBDVEUgcXVlcnkiCgpUaGUgcHJv YmxlbWF0aWMgcXVlcnkgaXM6Cmh0dHBzOi8vZ2l0aHViLmNvbS9vcGVuc3RyZWV0bWFwLW5nL29w ZW5zdHJlZXRtYXAtbmcvYmxvYi9lYjgwNWQ4NzY2ZmI0YjM1OWI5NmViNmI1MGFjYzhjMmE4MzVh MTY1L2FwcC9zZXJ2aWNlcy9lbGVtZW50X3NwYXRpYWxfc2VydmljZS5weSNMODItTDIxNQoKU3Bl Y2lmaWNhbGx5LCB0aGUgYFdJVEggbWVtYmVyX2dlb21zIC4uLmAgcGFydCBpbnNpZGUgdGhlIGBM RUZUIEpPSU4KTEFURVJBTGAuCgpJIHdhcyBhYmxlIHRvIHJlc29sdmUgdGhlIGlzc3VlIGJ5IGZv cmNpbmcgdGhlIExBVEVSQUwgQ1RFcyBhcyBOT1QKTUFURVJJQUxJWkVEOgotLS0gYXBwL3NlcnZp Y2VzL2VsZW1lbnRfc3BhdGlhbF9zZXJ2aWNlLnB5CisrKyBhcHAvc2VydmljZXMvZWxlbWVudF9z cGF0aWFsX3NlcnZpY2UucHkKQEAgLTE1NSwzICsxNTUsMyBAQCByZWxzX2NvbXB1dGVkIEFTICgK ICAgICBMRUZUIEpPSU4gTEFURVJBTCAoCi0gICAgICAgIFdJVEggbWVtYmVyX2dlb21zIEFTICgK KyAgICAgICAgV0lUSCBtZW1iZXJfZ2VvbXMgQVMgTk9UIE1BVEVSSUFMSVpFRCAoCiAgICAgICAg ICAgICBTRUxFQ1QgU1RfQ29sbGVjdChnZW9tX3ZhbCkgQVMgZ2VvbQpAQCAtMTc5LDMgKzE3OSwz IEBAIHJlbHNfY29tcHV0ZWQgQVMgKAogICAgICAgICApLAotICAgICAgICBub2RlZF9nZW9tcyBB UyAoCisgICAgICAgIG5vZGVkX2dlb21zIEFTIE5PVCBNQVRFUklBTElaRUQgKAogICAgICAgICAg ICAgU0VMRUNUIFNUX1VuYXJ5VW5pb24oU1RfQ29sbGVjdCgKQEAgLTE4NiwzICsxODYsMyBAQCBy ZWxzX2NvbXB1dGVkIEFTICgKICAgICAgICAgKSwKLSAgICAgICAgcG9seWdvbl9nZW9tcyBBUyAo CisgICAgICAgIHBvbHlnb25fZ2VvbXMgQVMgTk9UIE1BVEVSSUFMSVpFRCAoCiAgICAgICAgICAg ICBTRUxFQ1QgU1RfVW5hcnlVbmlvbihTVF9Db2xsZWN0KAoKVGhpcyBzZWVtcyBsaWtlIGEgcmVn cmVzc2lvbiBiZWNhdXNlIGluIGNhc2VzIHdoZXJlIGEgQ1RFIGhhcyBhbiBvdXRlcgpyZWZlcmVu Y2UsIGl0IHNpbXBseSBzaG91bGRuJ3QgYmUgbWF0ZXJpYWxpemVkIChJIGRvbid0IHJlYWxseSBr bm93IHRoZQpQb3N0Z3JlcyBpbnRlcm5hbHMpLiBJIG5ldmVyIGV4cGVjdGVkIHRoZXNlIENURXMg dG8gYmUgbWF0ZXJpYWxpemVkLiBJCnNpbXBseSB1c2UgdGhlbSBmb3IgaW1wcm92ZWQgcmVhZGFi aWxpdHkuCgo= --===============2542117657721242238==--