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 1rebHo-00CH29-5z for pgsql-bugs@arkaria.postgresql.org; Mon, 26 Feb 2024 13:44:52 +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 1rebHm-00DeNx-EO for pgsql-bugs@arkaria.postgresql.org; Mon, 26 Feb 2024 13:44:50 +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 1reamC-00DSG8-DW for pgsql-bugs@lists.postgresql.org; Mon, 26 Feb 2024 13:12:13 +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.94.2) (envelope-from ) id 1ream5-001AB7-6B for pgsql-bugs@lists.postgresql.org; Mon, 26 Feb 2024 13:12:12 +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=9MM0XAJp//c/7V5slTHhHuEWODX2lkTa7mACF+dJBvQ=; b=OkT/RZ1bx4vrSM8CGKYcpPg6rv oGIfWokabxyzv4jCSVYwqO7YVZQt9vVcCPQQ70s6n5iS7KIsDTXWZyr91e1dnKtS+6p8+xOPK1XSc 75fVGfAeSb2X+JdN4sbT2JHaou0nFDSNZRInV49L17IWMRnu42PI9OBegONa4Z7AgVCvtaq83/uKD JAA4htftlJfblcnuZ9vV0PZO5kRBbPYv8gXLXWXFYgoT9tOhgSqCXm4in12NparGJ0k86gjUzB9QH Zl7CMWB5wbR4Rpi4eEouSHL6Z8PbWw9B6OWzbolIIZvqotRq0lRKvudyBZhXVJalRumMdPdhAT3xZ agW940fg==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ream3-0031mI-BN for pgsql-bugs@lists.postgresql.org; Mon, 26 Feb 2024 13:12:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ream1-007dDr-Mw for pgsql-bugs@lists.postgresql.org; Mon, 26 Feb 2024 13:12:02 +0000 Content-Type: multipart/mixed; boundary="===============2196207605161228632==" MIME-Version: 1.0 Subject: BUG #18365: Inconsistent cost function between materialized and non-materialized CTE To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: postgresql@sjorsgielen.nl Reply-To: postgresql@sjorsgielen.nl, pgsql-bugs@lists.postgresql.org Date: Mon, 26 Feb 2024 13:11:33 +0000 Message-ID: <18365-ea9982ad685d4cb9@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 --===============2196207605161228632== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODM2NQpMb2dnZWQgYnk6ICAgICAgICAgIFNqb3JzIEdpZWxlbgpFbWFp bCBhZGRyZXNzOiAgICAgIHBvc3RncmVzcWxAc2pvcnNnaWVsZW4ubmwKUG9zdGdyZVNRTCB2ZXJz aW9uOiAxNi4yCk9wZXJhdGluZyBzeXN0ZW06ICAgTGludXggKG5hdGl2ZSBhbWQ2NCBhbmQgRG9j a2VyIGZvciBNYWMgYXJtNjQpCkRlc2NyaXB0aW9uOiAgICAgICAgCgpEZWFyIGFsbCwNCg0KSSBo YXZlIHJ1biBpbnRvIGFuIGlzc3VlIHdoZXJlIGEgcXVlcnkgd2l0aCBhIENURSBwZXJmb3JtcyBh IHNlcXVlbnRpYWwgc2NhbgpvbiBhIGxhcmdlIHRhYmxlICg0Mk0gcm93cywgfjFtaW4gb24gb3Vy IHByb2QpLCB3aGlsZSBleHBsaWNpdGx5Cm1hdGVyaWFsaXppbmcgdGhlIENURSBzaW1wbHkgcGVy Zm9ybXMgYW4gaW5kZXggb25seSBzY2FuICh+MnMpLiBXaGVuIEkgc2V0CmBlbmFibGVfc2Vxc2Nh bj1vZmZgIGFuZCBjb21wYXJlIHRoZSBjb3N0cywgaXQgdHVybnMgb3V0IHRoZSBxdWVyeSBwbGFu bmVyCmdyb3NzbHkgb3ZlcmVzdGltYXRlcyB0aGUgY29zdCBvZiBhIE5lc3RlZCBMb29wIGNvbXBh cmVkIHRvIHRoZSAoYXMgZmFyIGFzIEkKY2FuIHRlbGwpIGV4YWN0IHNhbWUgTmVzdGVkIExvb3Ag d2hlbiB0aGUgQ1RFIGlzIG1hdGVyaWFsaXplZC4gSSBrbm93IHRoYXQKdGhlIHF1ZXJ5IHBsYW5u ZXIgYWN0cyBvbiBoZXVyaXN0aWNzLCBzbyB0aGlzIG1pZ2h0IG5vdCBiZSBjb25zaWRlcmVkIGEg YnVnLApidXQgdGhlIGNvc3QgdmFsdWVzIGFyZSBzbyB3aWxkbHkgZGlmZmVyZW50IGZvciB3aGF0 IHNob3VsZCBiZSBlc3NlbnRpYWxseQp0aGUgc2FtZSBvcGVyYXRpb24sIHRoYXQgaXQgbWlnaHQg d2FycmFudCBmdXJ0aGVyIGludmVzdGlnYXRpb24uDQoNCkkgY2FuIHJlcHJvZHVjZSB0aGUgaXNz dWUgb24gUG9zdGdyZVNRTCAxNS4yLCAxNS42LCAxNi4yIGFuZCAxN2RldmVsIGFzIG9mCjIwMjQw MjIzLjE2MzYuZ2QzNjBlM2MuDQoNCkkgaGF2ZSByZXBvcnRlZCB0aGUgaXNzdWUsIHRoZSBzY2hl bWEsIHRoZSBxdWVyeSBhbmQgdGhlIHF1ZXJ5IHBsYW4gb3V0cHV0cwphdAo8aHR0cHM6Ly9kYmEu c3RhY2tleGNoYW5nZS5jb20vcXVlc3Rpb25zLzMzNTU3MC93aHktaXMtcG9zdGdyZXNxbC1wZXJm b3JtaW5nLWEtc2VxdWVudGlhbC1zY2FuLWV4Y2VwdC13aGVuLW15LWN0ZS1pcy1tYXRlcmlhbGl6 Pi4KQWxzbywgaW4gb3JkZXIgdG8gZmFjaWxpdGF0ZSByZXByb2R1Y3Rpb24sIEkgaGF2ZSB1cGxv YWRlZCB0d28gcmVwcm9kdWN0aW9uCnNjcmlwdHMgYW5kIGEgMSBHQiBzYW1wbGUgb2YgbXkgZGF0 YXNldCB3aGljaCBzdGlsbCByZXByb2R1Y2VzIHRoZSBpc3N1ZSBhdAo8aHR0cHM6Ly9zam9yc2dp ZWxlbi5ubC9wc3FsLWJ1Zy1yZXBvcnQudGFyLmd6Pi4gYGJyaW5nLXVwLnNoYCBydW5zIGEgZ2l2 ZW4KdmVyc2lvbiBvZiB0aGUgUG9zdGdyZVNRTCBEb2NrZXIgaW1hZ2UgbGlzdGVuaW5nIG9uIGxv Y2FsIHBvcnQgMTU0MzIuCmBydW4tdGVzdC5zaGAgY3JlYXRlcyB0aGUgYHRlc3RpbmdgIHNjaGVt YSwgY3JlYXRlcyB0aGUgRERMLCBhbmQgaW1wb3J0cyB0aGUKZGF0YSBmcm9tIGRhdGEuc3FsLmJ6 Mi4gSXQgc2hvdWxkIGJlIGVhc3kgdG8gcnVuIGBydW4tdGVzdC5zaGAgYWdhaW5zdCBhbnkKUG9z dGdyZXMgc2VydmVyIGJ5IGNoYW5naW5nIHRoZSBEU04gYXQgdGhlIHRvcCBvZiB0aGUgc2NyaXB0 LiBUaGUgYHRlc3RpbmdgCnNjaGVtYSBpcyBleHBlY3RlZCBub3QgdG8gZXhpc3QuDQoNCkJ5IHJ1 bm5pbmcgYC4vYnJpbmctdXAuc2ggMTYuMiAmJiAuL3J1bi10ZXN0LnNoYCwgc29tZSBtaW51dGVz IGxhdGVyLCB5b3UKc2hvdWxkIHNlZSB0aGUgb3V0cHV0IG9mIHRocmVlIGBFWFBMQUlOIChBTkFM WVpFLCBCVUZGRVJTLCBWRVJCT1NFKWAuIEkKd291bGQgZXhwZWN0IHRoZSBjb3N0IG9mIHRoZSBO ZXN0ZWQgTG9vcCBpbiB0aGUgZmlyc3QgY2FzZSAobWF0ZXJpYWxpemVkCnZpZXcpLCB3aGljaCBp cyBgMjI0Ni4uNzY2NTdgIChhcm91bmQgNzVrKSwgdG8gYmUgbW9yZSBvciBsZXNzIHRoZSBzYW1l IGFzCnRoYXQgb2YgdGhlIE5lc3RlZCBMb29wIGluIHRoZSB0aGlyZCBjYXNlIChzZXF1ZW50aWFs IHNjYW4gZGlzYWJsZWQpLCB3aGljaAppcyAyMzAzMTAuLjc5NzU4MSAofjU3MGspLiBCZWNhdXNl IHRoaXMgY29zdCBpcyBtdWNoIGhpZ2hlciwgZXZlbiBzdXJwYXNzaW5nCnRoZSBIYXNoIEpvaW4g Y29zdCBvZiB+MjkwaywgUG9zdGdyZVNRTCBkZWNpZGVzIHRvIHVzZSBhIHNlcXVlbnRpYWwgc2Nh biBpbgp0aGUgc2Vjb25kIGNhc2UgKG5vbi1tYXRlcmlhbGl6ZWQgdmlldykgd2hpY2ggZW5kcyB1 cCBjYXVzaW5nIGEgc2xvd2Rvd24gb2YKfjYuNSB0aW1lcy4NCg0KSXMgdGhpcyBhIGJ1Zz8NCg0K VGhhbmsgeW91LA0KU2pvcnMgR2llbGVuCgo= --===============2196207605161228632==--