Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kkPxm-0006LP-Hn for pgsql-bugs@arkaria.postgresql.org; Wed, 02 Dec 2020 11:06:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kkPxl-00012Y-7d for pgsql-bugs@arkaria.postgresql.org; Wed, 02 Dec 2020 11:06:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kkPcH-0004eu-Kr for pgsql-bugs@lists.postgresql.org; Wed, 02 Dec 2020 10:44:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kkPcE-0008W2-5C for pgsql-bugs@lists.postgresql.org; Wed, 02 Dec 2020 10:44: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=raE0TetsLXDi60Yv+tRooqXw3UhUGSlj7UWBDap4fKs=; b=bbDDx2OKg8OkaUBvx8I8LideEF sB3H6dpR4EkYe6lW6Xcm8dqXKinRaGRbzeGlDqgn1mCpj/ZM6z7iqeTLWvAJtsOMhRr232eE+3bvG SeMJW3r8JTn/ZB8xLNDl3Hp2dUqKjgGfdvb8XtvBn3UtgV86jqvcNcze7O8Odg3ksqVO5cOPK4v8b ZNZObMWgy4Rd7PLwpkzPUkLflW6m52EdvCnklbpr1V+1zon+8L5DCFRJSmEEXdUpZQJdm53Dddw5d t8b0AbPK9CzJ5tMUgDPjt3celZqs5R9mt4c0RE+Kif1AtrEgTtaoBGXZQPxJk/Jibqo95YZ08pNFl fBdFWP9Q==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kkPcD-00073a-DW for pgsql-bugs@lists.postgresql.org; Wed, 02 Dec 2020 10:44:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kkPc9-0001FV-Ty for pgsql-bugs@lists.postgresql.org; Wed, 02 Dec 2020 10:44:01 +0000 Content-Type: multipart/mixed; boundary="===============8366720457529358799==" MIME-Version: 1.0 Subject: BUG #16759: Estimation of the planner is wrong for hash join To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: bertrand.guillaumin@gmail.com Reply-To: bertrand.guillaumin@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 02 Dec 2020 10:43:50 +0000 Message-ID: <16759-f0980add03d8f152@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============8366720457529358799== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjc1OQpMb2dnZWQgYnk6ICAgICAgICAgIEJlcnRyYW5kIEd1aWxsYXVt aW4KRW1haWwgYWRkcmVzczogICAgICBiZXJ0cmFuZC5ndWlsbGF1bWluQGdtYWlsLmNvbQpQb3N0 Z3JlU1FMIHZlcnNpb246IDExLjgKT3BlcmF0aW5nIHN5c3RlbTogICBMaW51eApEZXNjcmlwdGlv bjogICAgICAgIAoKVGhlIGZvbGxvd2luZyBxdWVyeSBlc3RpbWF0ZWQgbnVtYmVyIG9mIGxpbmVz IHJldHVybmVkIGlzIDEgd2hpbGUgaXQgc2hvdWxkCmJlIGFyb3VuZCA2NyBvciBtb3JlIDogDQpl eHBsYWluIGFuYWx5emUgc2VsZWN0ICogZnJvbSBlbnRlcnByaXNlIHdoZXJlIHBhcmVudF9lbnRl cnByaXNlIGluIChzZWxlY3QKZW50ZXJwcmlzZV9pZCBmcm9tIGVudGVycHJpc2UgcGFyIHdoZXJl IGdsb2JhbF9hdHRyaWJ1dGUxNSA9ICdCRUwnKTsNCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgUVVFUlkgUExBTg0KLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogSGFzaCBKb2luICAo Y29zdD05NS42MC4uMTkxLjMzIHJvd3M9MSB3aWR0aD05NzcpIChhY3R1YWwgdGltZT0wLjQyMi4u MC44OTYKcm93cz01NiBsb29wcz0xKQ0KICAgSGFzaCBDb25kOiAoZW50ZXJwcmlzZS5wYXJlbnRf ZW50ZXJwcmlzZSA9IHBhci5lbnRlcnByaXNlX2lkKQ0KICAgLT4gIFNlcSBTY2FuIG9uIGVudGVy cHJpc2UgIChjb3N0PTAuMDAuLjkyLjg3IHJvd3M9MTA4NyB3aWR0aD05NzcpCihhY3R1YWwgdGlt ZT0wLjAwNC4uMC4wOTUgcm93cz0xMDg3IGxvb3BzPTEpDQogICAtPiAgSGFzaCAgKGNvc3Q9OTUu NTkuLjk1LjU5IHJvd3M9MSB3aWR0aD01KSAoYWN0dWFsIHRpbWU9MC4zOTcuLjAuMzk4CnJvd3M9 MSBsb29wcz0xKQ0KICAgICAgICAgQnVja2V0czogMTAyNCAgQmF0Y2hlczogMSAgTWVtb3J5IFVz YWdlOiA5a0INCiAgICAgICAgIC0+ICBTZXEgU2NhbiBvbiBlbnRlcnByaXNlIHBhciAgKGNvc3Q9 MC4wMC4uOTUuNTkgcm93cz0xIHdpZHRoPTUpCihhY3R1YWwgdGltZT0wLjI1MS4uMC4zOTQgcm93 cz0xIGxvb3BzPTEpDQogICAgICAgICAgICAgICBGaWx0ZXI6IChnbG9iYWxfYXR0cmlidXRlMTUg PSAnQkVMJzo6dGV4dCkNCiAgICAgICAgICAgICAgIFJvd3MgUmVtb3ZlZCBieSBGaWx0ZXI6IDEw ODYNCg0KVGhlIHNhbWUgaXNzdWUgd2l0aCBhIG5vcm1hbCBqb2luIDogDQpleHBsYWluIGFuYWx5 emUgc2VsZWN0ICogZnJvbSBlbnRlcnByaXNlICBlbnQxLCBlbnRlcnByaXNlIGVudDIgd2hlcmUK ZW50MS5wYXJlbnRfZW50ZXJwcmlzZT1lbnQyLmVudGVycHJpc2VfaWQgYW5kIGVudDIuZ2xvYmFs X2F0dHJpYnV0ZTE1ID0KJ0JFTCc7DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgUVVFUlkgUExBTg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogSGFzaCBKb2luICAoY29z dD05NS42MC4uMTkxLjMzIHJvd3M9MSB3aWR0aD0xOTU0KSAoYWN0dWFsIHRpbWU9MC40NDQuLjAu OTU0CnJvd3M9NTYgbG9vcHM9MSkNCiAgIEhhc2ggQ29uZDogKGVudDEucGFyZW50X2VudGVycHJp c2UgPSBlbnQyLmVudGVycHJpc2VfaWQpDQogICAtPiAgU2VxIFNjYW4gb24gZW50ZXJwcmlzZSBl bnQxICAoY29zdD0wLjAwLi45Mi44NyByb3dzPTEwODcgd2lkdGg9OTc3KQooYWN0dWFsIHRpbWU9 MC4wMDQuLjAuMTA0IHJvd3M9MTA4NyBsb29wcz0xKQ0KICAgLT4gIEhhc2ggIChjb3N0PTk1LjU5 Li45NS41OSByb3dzPTEgd2lkdGg9OTc3KSAoYWN0dWFsIHRpbWU9MC40MTYuLjAuNDE2CnJvd3M9 MSBsb29wcz0xKQ0KICAgICAgICAgQnVja2V0czogMTAyNCAgQmF0Y2hlczogMSAgTWVtb3J5IFVz YWdlOiA5a0INCiAgICAgICAgIC0+ICBTZXEgU2NhbiBvbiBlbnRlcnByaXNlIGVudDIgIChjb3N0 PTAuMDAuLjk1LjU5IHJvd3M9MQp3aWR0aD05NzcpIChhY3R1YWwgdGltZT0wLjI1Mi4uMC40MTAg cm93cz0xIGxvb3BzPTEpDQogICAgICAgICAgICAgICBGaWx0ZXI6IChnbG9iYWxfYXR0cmlidXRl MTUgPSAnQkVMJzo6dGV4dCkNCiAgICAgICAgICAgICAgIFJvd3MgUmVtb3ZlZCBieSBGaWx0ZXI6 IDEwODYNCg0KDQpUaGUgc3RhdGlzdGljcyBmb3IgcGFyZW50X2VudGVycHJpc2UgOiANCnNlbGVj dCAqIGZyb20gcGdfc3RhdHMgd2hlcmUgdGFibGVuYW1lPSdlbnRlcnByaXNlJyBhbmQKYXR0bmFt ZT0ncGFyZW50X2VudGVycHJpc2UnOw0KIHNjaGVtYW5hbWUgfCB0YWJsZW5hbWUgIHwgICAgICBh dHRuYW1lICAgICAgfCBpbmhlcml0ZWQgfCBudWxsX2ZyYWMgIHwKYXZnX3dpZHRoIHwgbl9kaXN0 aW5jdCB8ICAgICAgICAgICAgICAgICAgbW9zdF9jb21tb25fdmFscyAgICAgICAgICAgICAgICAg IAp8DQptb3N0X2NvbW1vbl9mcmVxcyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgfCAgIApoaXN0b2dyYW1fYm91bmRzICAgICB8IGNvcnJlbGF0aW9uIHwg bW9zdF9jb21tb25fZWxlbXMgfAptb3N0X2NvbW1vbl9lbGVtX2ZyZXFzIHwgZWxlbV9jb3VudF9o aXN0b2dyYW0NCi0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLSst LS0tLS0tLS0tLSstLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tKy0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCi0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0rLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCnh4eHh4eHggICAg IHwgZW50ZXJwcmlzZSB8IHBhcmVudF9lbnRlcnByaXNlIHwgZiAgICAgICAgIHwgMC4wMDU1MTk3 OCB8ICAgICAKICAgNCB8ICAgICAgICAgMTYgfCB7NDgsNjgyLDYxNjIsNjYzOSw2NDQ4LDQ2LDY2 MzAsNjc5Niw2NTUzLDY4MTIsNjg1NH0gfAp7MC41NTEwNTgsMC4xODQ5MTMsMC4wODE4NzY3LDAu MDc3Mjc2OSwwLjA1MTUxNzkNCiwwLjAxMzc5OTQsMC4wMDkxOTk2MywwLjAwODI3OTY3LDAuMDA2 NDM5NzQsMC4wMDM2Nzk4NSwwLjAwMTgzOTkzfSB8CnswLDY4MzEsNjg1Myw2OTA0LDY5MTd9IHwg ICAgMC43NTUwNDIgfCAgICAgICAgICAgICAgICAgICB8ICAgICAgICAgICAgICAgICAKICAgICAg fA0KKDEgcm93KQ0KDQpUaGUgcmlnaHQgZXN0aW1hdGlvbiB3aGVuIHVzaW5nID0gKG5vdCBhbiBv cHRpb24gaGVyZSk6IA0KZXhwbGFpbiBzZWxlY3QgKiBmcm9tIGVudGVycHJpc2Ugd2hlcmUgcGFy ZW50X2VudGVycHJpc2UgPSAoc2VsZWN0CmVudGVycHJpc2VfaWQgZnJvbSBlbnRlcnByaXNlIHBh ciB3aGVyZSBnbG9iYWxfYXR0cmlidXRlMTUgPSAnQkVMJyBsaW1pdAoxKTsNCiAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgIFFVRVJZIFBMQU4NCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogU2VxIFNjYW4g b24gZW50ZXJwcmlzZSAgKGNvc3Q9OTUuNTkuLjE5MS4xOCByb3dzPTY4IHdpZHRoPTk3NykNCiAg IEZpbHRlcjogKHBhcmVudF9lbnRlcnByaXNlID0gJDApDQogICBJbml0UGxhbiAxIChyZXR1cm5z ICQwKQ0KICAgICAtPiAgU2VxIFNjYW4gb24gZW50ZXJwcmlzZSBwYXIgIChjb3N0PTAuMDAuLjk1 LjU5IHJvd3M9MSB3aWR0aD01KQ0KICAgICAgICAgICBGaWx0ZXI6IChnbG9iYWxfYXR0cmlidXRl MTUgPSAnQkVMJzo6dGV4dCkNCg0KVGhlIHdyb25nIGVzdGltYXRpb24gbGVhZHMgdG8gaXNzdWVz IGluIGJpZ2dlciBxdWVyaWVzLgoK --===============8366720457529358799==--