Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1jHqvv-0002zA-Mm for pgsql-bugs@arkaria.postgresql.org; Fri, 27 Mar 2020 15:30:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jHqvu-0008KZ-H0 for pgsql-bugs@arkaria.postgresql.org; Fri, 27 Mar 2020 15:30:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1jHqvu-0008Ia-92 for pgsql-bugs@lists.postgresql.org; Fri, 27 Mar 2020 15:30:06 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jHqvr-0004b9-6i for pgsql-bugs@lists.postgresql.org; Fri, 27 Mar 2020 15:30:05 +0000 Content-Type: multipart/mixed; boundary="===============2166625759419433651==" MIME-Version: 1.0 Subject: BUG #16324: bad cost estimates for generic query plans To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: tcook@blackducksoftware.com Reply-To: tcook@blackducksoftware.com, pgsql-bugs@lists.postgresql.org Date: Fri, 27 Mar 2020 15:29:29 +0000 Message-ID: <16324-32ad11f2ab803917@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============2166625759419433651== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjMyNApMb2dnZWQgYnk6ICAgICAgICAgIFRvZGQgQ29vawpFbWFpbCBh ZGRyZXNzOiAgICAgIHRjb29rQGJsYWNrZHVja3NvZnR3YXJlLmNvbQpQb3N0Z3JlU1FMIHZlcnNp b246IDExLjcKT3BlcmF0aW5nIHN5c3RlbTogICBDZW50T1MgNy43CkRlc2NyaXB0aW9uOiAgICAg ICAgCgpXaXRoIFBHIDExLjcsIHdlJ3JlIHNlZWluZyBiYWQgY29zdCBlc3RpbWF0ZXMgZm9yIGdl bmVyaWMgcXVlcnkgcGxhbnMgd2hlcmUKdGhlIGNvc3Qgb2YNCmEgdmVyeSBleHBlbnNpdmUgSW5p dFBsYW4gaXMgbm90IGluY2x1ZGVkIGluIHRoZSB0b3RhbCBjb3N0Lg0KDQoJdGVzdD0jIHNlbGVj dCB2ZXJzaW9uKCkgOw0KCQkJCQkJCQkJCQkJCSB2ZXJzaW9uICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KCS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KCSBQb3N0Z3JlU1FMIDExLjcgb24geDg2XzY0LXBjLWxp bnV4LWdudSwgY29tcGlsZWQgYnkgZ2NjIChHQ0MpIDQuOC41CjIwMTUwNjIzIChSZWQgSGF0IDQu OC41LTM5KSwgNjQtYml0DQoNCg0KVGhlIGluaXRpYWwgY3VzdG9tIHBsYW4gaXMgdmVyeSBnb29k Og0KDQoJdGVzdD0jIHByZXBhcmUgczEgYXMgU0VMRUNUIEVYSVNUUyhTRUxFQ1QgMSBGUk9NIGF1 ZGl0X2V2ZW50IFdIRVJFIGlkID4gJDEKQU5EIGV2ZW50X25hbWUgSU4gKCQyLCQzLCQ0LCQ1LCQ2 LCQ3LCQ4LCQ5LCQxMCkpIDsNCglQUkVQQVJFDQoJdGVzdD0jIGV4cGxhaW4gYW5hbHl6ZSBleGVj dXRlIHMxKDMxNjk0NTY5OSwgJ0NWQScsICdDVkNDJywgJ0NWSUMnLAonQ1ZSREMnLCAnQ1ZSJywg J0NWU0MnLCAnQ1ZUQycsICdDQkUnLCAnVkJDTEJDJykgOw0KCQkJCQkJCQkJCQkJCQkJCSAgUVVF UlkgUExBTiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAog ICAgICAgICAgIA0KCS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQoJIFJlc3VsdCAgKGNvc3Q9NC42MC4u NC42MSByb3dzPTEgd2lkdGg9MSkgKGFjdHVhbCB0aW1lPTAuMDA5Li4wLjAwOSByb3dzPTEKbG9v cHM9MSkNCgkgICBJbml0UGxhbiAxIChyZXR1cm5zICQwKQ0KCQkgLT4gIEluZGV4IFNjYW4gdXNp bmcgYXVkaXRfZXZlbnRfcGtleSBvbiBhdWRpdF9ldmVudCAgKGNvc3Q9MC41Ny4uNC42MApyb3dz PTEgd2lkdGg9MCkgKGFjdHVhbCB0aW1lPTAuMDA3Li4wLjAwNyByb3dzPTAgbG9vcHM9MSkNCgkJ CSAgIEluZGV4IENvbmQ6IChpZCA+ICczMTY5NDU2OTknOjpiaWdpbnQpDQoJCQkgICBGaWx0ZXI6 IChldmVudF9uYW1lID0gQU5ZCigne0NWQSxDVkNDLENWSUMsQ1ZSREMsQ1ZSLENWU0MsQ1ZUQyxD QkUsVkJDTEJDfSc6OnRleHRbXSkpDQoJIFBsYW5uaW5nIFRpbWU6IDAuNDAzIG1zDQoJIEV4ZWN1 dGlvbiBUaW1lOiAwLjAzMyBtcw0KCSg3IHJvd3MpDQoNClRoZSBhdWRpdF9ldmVudCB0YWJsZSBo YXMgODIgbWlsbGlvbiByb3dzLCBhbmQgdGhlIGxpc3RlZCBldmVudF9uYW1lcwphY2NvdW50IGZv ciBhYm91dA0KMTUgbWlsbGlvbiBvZiB0aGVtLiAgSG93ZXZlciwgMzE2OTQ1Njk5IGlzIHRoZSBt YXhpbXVtIGlkIHZhbHVlLCBzbyB0aGUKZXhpc3RlbmNlIGNoZWNrDQpyZXR1cm5zIGZhbHNlLg0K DQpUaGVuLCBhZnRlciA1IGludm9jYXRpb25zLCBQRyBzd2l0Y2hlcyB0byB1c2luZyBhIGNhY2hl ZCwgZ2VuZXJpYyBxdWVyeSBwbGFuCnRoYXQgaXMNCnZlcnkgc2xvdzoNCg0KCXRlc3Q9IyBleHBs YWluIGFuYWx5emUgZXhlY3V0ZSBzMSgzMTY5NDU2OTksICdDVkEnLCAnQ1ZDQycsICdDVklDJywK J0NWUkRDJywgJ0NWUicsICdDVlNDJywgJ0NWVEMnLCAnQ0JFJywgJ1ZCQ0xCQycpIDsNCgkJCQkJ CQkJCQkJCQkJCQlRVUVSWSBQTEFOICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAKICAgICAgICAgDQoJLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KCSBSZXN1bHQgIChj b3N0PTAuNDcuLjAuNDggcm93cz0xIHdpZHRoPTEpIChhY3R1YWwgdGltZT0yODMxNC45NjAuLjI4 MzE0Ljk2MQpyb3dzPTEgbG9vcHM9MSkNCgkgICBJbml0UGxhbiAxIChyZXR1cm5zICQwKQ0KCQkg LT4gIFNlcSBTY2FuIG9uIGF1ZGl0X2V2ZW50ICAoY29zdD0wLjAwLi42Nzk2ODc3LjY3IHJvd3M9 MTQ1MzIyNzIKd2lkdGg9MCkgKGFjdHVhbCB0aW1lPTI4MzE0Ljk1My4uMjgzMTQuOTUzIHJvd3M9 MCBsb29wcz0xKQ0KCQkJICAgRmlsdGVyOiAoKGlkID4gJDEpIEFORCAoZXZlbnRfbmFtZSA9IEFO WSAoQVJSQVlbJDIsICQzLCAkNCwgJDUsICQ2LAokNywgJDgsICQ5LCAkMTBdKSkpDQoJCQkgICBS b3dzIFJlbW92ZWQgYnkgRmlsdGVyOiA4MjM0OTU0Nw0KCSBQbGFubmluZyBUaW1lOiAwLjM3NyBt cw0KCSBFeGVjdXRpb24gVGltZTogMjgzMTUuMDAzIG1zDQoJKDcgcm93cykNCg0KSXQgbG9va3Mg bGlrZSB0aGUgdG90YWwgY29zdCBvZiB0aGUgcGxhbiBpcyBub3QgaW5jbHVkaW5nIHRoZSBzdWJz dGFudGlhbApjb3N0IG9mDQp0aGUgSW5pdFBsYW4uDQoNCkZXSVcsIDkuNi4xNyBleGhpYml0cyB0 aGUgc2FtZSBiZWhhdmlvci4KCg== --===============2166625759419433651==--