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 1uWFB1-00AnPg-8k for pgsql-bugs@arkaria.postgresql.org; Mon, 30 Jun 2025 14:08:07 +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 1uWFAy-0000Kg-5C for pgsql-bugs@arkaria.postgresql.org; Mon, 30 Jun 2025 14:08:04 +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 1uWEom-00HWhN-Vg for pgsql-bugs@lists.postgresql.org; Mon, 30 Jun 2025 13:45:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uWEol-004lsi-38 for pgsql-bugs@lists.postgresql.org; Mon, 30 Jun 2025 13:45:08 +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=+6lRbYxydm67kYsv6FqbbE16YEIjGWx2UeQPfLEeUy4=; b=4ccBWJ6Cf1AMrqitQ/FWKuDvhm sq8QeYnNH+ElEsE5pLbLUpQ4dWJU2ECZCFPcstFN6ZYPglM04ypNxlrOyJwRj4Q6GCTofx3IOImFq 67oAEYO/tkaeI1k3ihxb72s51CVZkLQ3edFT3pFwnGzUeevnsypx+/uX2Sds5D3NUOCjt7JVWNqWa LmKk+66l3jdIC6wjhp+yFsgapGSZvwZQW9Y8/2v9wCANeu0nP2XYvVd4RiYjU8LXY0M30ibepaa15 rIVLvStFWgVtZycnr7ntoUd1yCs1gg0bvZGjC/5LAFGutnuvuLYMKGxc2mQHZqpA+l+9foALKsGAO GFHIqDLA==; 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 1uWEoj-00DR82-7t for pgsql-bugs@lists.postgresql.org; Mon, 30 Jun 2025 13:45:07 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uWEoi-00B9a4-00 for pgsql-bugs@lists.postgresql.org; Mon, 30 Jun 2025 13:45:04 +0000 Content-Type: multipart/mixed; boundary="===============1516117908979121671==" MIME-Version: 1.0 Subject: BUG #18973: The default enable_material=ON affects the cost estimation of optimizer, resulting in 10968x slow To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: jinhui-lai@foxmail.com Reply-To: jinhui-lai@foxmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 30 Jun 2025 13:44:19 +0000 Message-ID: <18973-3bc2a3f826a72cce@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 --===============1516117908979121671== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODk3MwpMb2dnZWQgYnk6ICAgICAgICAgIEppbmh1aQpFbWFpbCBhZGRy ZXNzOiAgICAgIGppbmh1aS1sYWlAZm94bWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxNy41 Ck9wZXJhdGluZyBzeXN0ZW06ICAgdWJ1bnR1IDIyLjA0CkRlc2NyaXB0aW9uOiAgICAgICAgCgpE ZWFyIFBHIGRldmVsb3BlcnMsClRoYW5rIHlvdSBmb3IgdGFraW5nIHRoZSB0aW1lIHRvIHJlYWQg bXkgcmVwb3J0LgpJIG1heSBoYXZlIGZvdW5kIGEgcGVyZm9ybWFuY2UgaXNzdWUuIFRoZSBwYXJh bWV0ZXIgZW5hYmxlX21hdGVyaWFsIGlzIHNldAp0byBPTiBieSBkZWZhdWx0LCBhbmQgaXQgYWZm ZWN0cyB0aGUgY29zdCBlc3RpbWF0aW9uIG9mIG9wdGltaXplciwgcmVzdWx0aW5nCmluIDEwOTY4 eCBzbG93LiBZb3UgY2FuIHJlcHJvZHVjZSBpdCBhcyBmb2xsb3dzOgpDUkVBVEUgVEFCTEUgdDAo YzAgSU5UOCk7CkNSRUFURSBUQUJMRSB0MShjMSBJTlQ4KTsKSU5TRVJUIElOVE8gdDEgU0VMRUNU IGkgRlJPTSBnZW5lcmF0ZV9zZXJpZXMoMSwgMTAwMDAwMDAwKSBBUyBpOwpTRUxFQ1QgKiBGUk9N IHQwIElOTkVSIEpPSU4gdDEgT04gdDAuYzAgIT0gdDEuYzE7CiBjMCB8IGMxCi0tLS0rLS0tLQoo MCByb3dzKQpUaW1lOiA5Nzk0LjAxNiBtcyAoMDA6MDkuNzk0KQpTRVQgZW5hYmxlX21hdGVyaWFs ID0gb2ZmOwpTRUxFQ1QgKiBGUk9NIHQwIElOTkVSIEpPSU4gdDEgT04gdDAuYzAgIT0gdDEuYzE7 CmMwIHwgYzEKLS0tLSstLS0tCigwIHJvd3MpClRpbWU6IDAuODkzIG1zClRoZSAgZW5hYmxlX21h dGVyaWFsPU9OIGFsc28gYWZmZWN0cyBDUk9TUy9OQVRVUkFMIEpPSU4sIGJ1dCBub3QgYWZmZWN0 cwpMRUZUIEpPSU46ClNFTEVDVCAqIEZST00gdDAgTkFUVVJBTCBKT0lOIHQxOwogYzAgfCBjMQot LS0tKy0tLS0KKDAgcm93cykKVGltZTogNzM1MC4yMTYgbXMgKDAwOjA3LjM1MCkKU0VMRUNUICog RlJPTSB0MCBDUk9TUyBKT0lOIHQxOwogYzAgfCBjMQotLS0tKy0tLS0KKDAgcm93cykKVGltZTog NjgyMy41MzIgbXMgKDAwOjA2LjgyNCkKU0VMRUNUICogRlJPTSB0MCBMRUZUIEpPSU4gdDEgT04g dDAuYzAgIT0gdDEuYzE7CiBjMCB8IGMxCi0tLS0rLS0tLQooMCByb3dzKQpUaW1lOiAwLjc5OCBt cwpBZGRpbmcgdGhlIGZvbGxvd2luZyBjb2RlIGluCnBvc3RncmVzL2Jsb2IvbWFzdGVyL3NyYy9i YWNrZW5kL29wdGltaXplci91dGlsL3BsYW5jYXQuYyBtYXkgd29ya3MKI2luY2x1ZGUgImNhdGFs b2cvcGdfc3RhdGlzdGljX2hpc3RvcnkuaCIKLi4uCmJvb2wgaXNfdGFibGVfdmFjdXVtZWRfb3Jf YW5hbHl6ZWQoT2lkIHJlbGlkKQp7CiAgICBSZWxhdGlvbiBwZ3N0YWhpcyA9IE5VTEw7CiAgICBT eXNTY2FuRGVzYyBzY2FuID0gTlVMTDsKICAgIFNjYW5LZXlEYXRhIGtleVsxXTsKICAgIEhlYXBU dXBsZSB0dXBsZSA9IE5VTEw7CiAgICBib29sIGZvdW5kID0gZmFsc2U7CiAgICBTY2FuS2V5SW5p dCgma2V5WzBdLCBBbnVtX3BnX3N0YXRpc3RpY19oaXN0b3J5X3N0YXJlbGlkLApCVEVxdWFsU3Ry YXRlZ3lOdW1iZXIsIEZfT0lERVEsIE9iamVjdElkR2V0RGF0dW0ocmVsaWQpKTsKICAgIHBnc3Rh aGlzID0gcmVsYXRpb25fb3BlbihTdGF0aXN0aWNIaXN0b3J5UmVsYXRpb25JZCwgQWNjZXNzU2hh cmVMb2NrKTsKICAgIHNjYW4gPSBzeXN0YWJsZV9iZWdpbnNjYW4ocGdzdGFoaXMsIFN0YXRpc3Rp Y0hpc3RvcnlUYWJUeXBBdHRudW1JbmRleElkLAp0cnVlLCBOVUxMLCAxLCBrZXkpOwogICAgaWYg KEhlYXBUdXBsZUlzVmFsaWQodHVwbGUgPSBzeXN0YWJsZV9nZXRuZXh0KHNjYW4pKSkgewogICAg ICAgIGZvdW5kID0gdHJ1ZTsKICAgIH0KICAgIHN5c3RhYmxlX2VuZHNjYW4oc2Nhbik7CiAgICBy ZWxhdGlvbl9jbG9zZShwZ3N0YWhpcywgQWNjZXNzU2hhcmVMb2NrKTsKICAgIHJldHVybiBmb3Vu ZDsKfQpCZXN0IHJlZ2FyZCwKSmluaHVpCgo= --===============1516117908979121671==--