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.89) (envelope-from ) id 1iydjn-0003K3-9N for pgsql-bugs@arkaria.postgresql.org; Mon, 03 Feb 2020 15:34:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iydim-00007v-WB for pgsql-bugs@arkaria.postgresql.org; Mon, 03 Feb 2020 15:33:08 +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 1iydim-00007m-Nm for pgsql-bugs@lists.postgresql.org; Mon, 03 Feb 2020 15:33:08 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1iydij-0001Jc-3i for pgsql-bugs@lists.postgresql.org; Mon, 03 Feb 2020 15:33:08 +0000 Content-Type: multipart/mixed; boundary="===============0493375972795982908==" MIME-Version: 1.0 Subject: BUG #16241: Degraded hash join performance To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: tbutz@optitool.de Reply-To: tbutz@optitool.de, pgsql-bugs@lists.postgresql.org Date: Mon, 03 Feb 2020 15:33:02 +0000 Message-ID: <16241-5af1a947ef860367@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============0493375972795982908== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjI0MQpMb2dnZWQgYnk6ICAgICAgICAgIFRob21hcyBCdXR6CkVtYWls IGFkZHJlc3M6ICAgICAgdGJ1dHpAb3B0aXRvb2wuZGUKUG9zdGdyZVNRTCB2ZXJzaW9uOiAxMi4x Ck9wZXJhdGluZyBzeXN0ZW06ICAgTW9kaWZpZWQgcG9zdGdyZXM6MTIgZG9ja2VyIGltYWdlIChE ZWJpYW4gQnVzdGVyKQpEZXNjcmlwdGlvbjogICAgICAgIAoKSSdtIGN1cnJlbnRseSBhbmFseXpp bmcgYSBzbG93ZG93biBpbiB0aGUgcGVyZm9ybWFuY2Ugb2Ygb3VyIE9TTSB0aWxlCnJlbmRlcmlu ZyB0b29sY2hhaW4uIFdoaWxlIHRoZSBmb2xsb3dpbmcgcXVlcnkgZmluaXNoZXMgcXVpdGUgZmFz dCB3aXRoClBvc3RncmVTUUwgMTEuNC9Qb3N0Z2lzIDIuNSBpdCB0YWtlcyBhIGxvdCBsb25nZXIg dXNpbmcgUG9zdGdyZVNRTAoxMi4xL1Bvc3RnaXMgMy4wOg0KDQpTRUxFQ1QgU1RfQXNCaW5hcnko IndheSIpIEFTIGdlb20sImNvbnN0cnVjdGlvbiIsImhpZ2h3YXkiLCJuYW1lIiwidHVubmVsIgpG Uk9NIChTRUxFQ1QNCiAgICAgICAgICAgIHdheSwNCiAgICAgICAgICAgIENBU0UgV0hFTiBzdWJz dHIoaGlnaHdheSwgbGVuZ3RoKGhpZ2h3YXkpLTQsIDUpID0gJ19saW5rJyBUSEVOCnN1YnN0ciho aWdod2F5LCAwLCBsZW5ndGgoaGlnaHdheSktNCkgRUxTRSBoaWdod2F5IEVORCwNCiAgICAgICAg ICAgIENBU0UgV0hFTiAodHVubmVsID0gJ3llcycgT1IgdHVubmVsID0gJ2J1aWxkaW5nX3Bhc3Nh Z2UnIE9SCmNvdmVyZWQgPSAneWVzJykgVEhFTiAneWVzJyBFTFNFICdubycgRU5EIEFTIHR1bm5l bCwNCiAgICAgICAgICAgIGNvbnN0cnVjdGlvbiwNCiAgICAgICAgICAgIGxvY2FsaXplZF9zdHJl ZXRuYW1lIGFzIG5hbWUsDQogICAgICAgICAgICBDQVNFDQogICAgICAgICAgICAgIFdIRU4gb25l d2F5IElOICgneWVzJywgJy0xJykgVEhFTiBvbmV3YXkNCiAgICAgICAgICAgICAgV0hFTiBqdW5j dGlvbiBJTiAoJ3JvdW5kYWJvdXQnKSBBTkQgKG9uZXdheSBJUyBOVUxMIE9SIE5PVApvbmV3YXkg SU4gKCdubycsICdyZXZlcnNpYmxlJykpIFRIRU4gJ3llcycNCiAgICAgICAgICAgICAgRUxTRSBO VUxMDQogICAgICAgICAgICBFTkQgQVMgb25ld2F5LA0KICAgICAgICAgICAgaG9yc2UsIGJpY3lj bGUNCiAgICAgICAgICBGUk9NIHBsYW5ldF9vc21fbGluZSBsDQogICAgICAgICAgSk9JTiAoVkFM VUVTIC0tIHRoaXMgam9pbiBpcyBhbHNvIHB1dHRpbmcgYSBjb25kaXRpb24gb24gd2hhdCBpcwpz ZWxlY3RlZC4gZmVhdHVyZXMgbm90IG1hdGNoaW5nIGl0IGRvIG5vdCBtYWtlIGl0IGludG8gdGhl IHJlc3VsdHMuDQogICAgICAgICAgICAgICgnbW90b3J3YXknLCAzODApLA0KICAgICAgICAgICAg ICAoJ3RydW5rJywgMzcwKSwNCiAgICAgICAgICAgICAgKCdwcmltYXJ5JywgMzYwKSwNCiAgICAg ICAgICAgICAgKCdzZWNvbmRhcnknLCAzNTApLA0KICAgICAgICAgICAgICAoJ3RlcnRpYXJ5Jywg MzQwKSwNCiAgICAgICAgICAgICAgKCdyZXNpZGVudGlhbCcsIDMzMCksDQogICAgICAgICAgICAg ICgndW5jbGFzc2lmaWVkJywgMzMwKSwNCiAgICAgICAgICAgICAgKCdyb2FkJywgMzMwKSwNCiAg ICAgICAgICAgICAgKCdsaXZpbmdfc3RyZWV0JywgMzIwKSwNCiAgICAgICAgICAgICAgKCdwZWRl c3RyaWFuJywgMzEwKSwNCiAgICAgICAgICAgICAgKCdyYWNld2F5JywgMzAwKSwNCiAgICAgICAg ICAgICAgKCdtb3RvcndheV9saW5rJywgMjQwKSwNCiAgICAgICAgICAgICAgKCd0cnVua19saW5r JywgMjMwKSwNCiAgICAgICAgICAgICAgKCdwcmltYXJ5X2xpbmsnLCAyMjApLA0KICAgICAgICAg ICAgICAoJ3NlY29uZGFyeV9saW5rJywgMjEwKSwNCiAgICAgICAgICAgICAgKCd0ZXJ0aWFyeV9s aW5rJywgMjAwKSwNCiAgICAgICAgICAgICAgKCdzZXJ2aWNlJywgMTUwKSwNCiAgICAgICAgICAg ICAgKCdjb25zdHJ1Y3Rpb24nLCAxMCkNCiAgICAgICAgICAgICkgQVMgb3JkZXJ0YWJsZSAoaGln aHdheSwgcHJpbykNCiAgICAgICAgICAgIFVTSU5HIChoaWdod2F5KQ0KICAgICAgICAgIFdIRVJF IGhpZ2h3YXkgSU4gKCdtb3RvcndheScsICdtb3RvcndheV9saW5rJywgJ3RydW5rJywKJ3RydW5r X2xpbmsnLCAncHJpbWFyeScsICdwcmltYXJ5X2xpbmsnLCAnc2Vjb25kYXJ5JywgJ3NlY29uZGFy eV9saW5rJywKJ3RlcnRpYXJ5JywNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAndGVydGlh cnlfbGluaycsICdyZXNpZGVudGlhbCcsICd1bmNsYXNzaWZpZWQnLAoncm9hZCcsICdzZXJ2aWNl JywgJ3BlZGVzdHJpYW4nLCAncmFjZXdheScsICdsaXZpbmdfc3RyZWV0JywKJ2NvbnN0cnVjdGlv bicpDQogICAgICAgICAgICBBTkQgKG5hbWUgSVMgTk9UIE5VTEwNCiAgICAgICAgICAgICAgT1Ig b25ld2F5IElOICgneWVzJywgJy0xJykNCiAgICAgICAgICAgICAgT1IganVuY3Rpb24gSU4gKCdy b3VuZGFib3V0JykpDQogICAgICAgICAgT1JERVIgQlkNCiAgICAgICAgICAgIHpfb3JkZXIgREVT QywgLS0gcHV0IGltcG9ydGFudCByb2FkcyBmaXJzdA0KICAgICAgICAgICAgQ09BTEVTQ0UobGF5 ZXIsIDApLCAtLSBwdXQgdG9wIGxheWVyZWQgcm9hZHMgZmlyc3QNCiAgICAgICAgICAgIGxlbmd0 aChuYW1lKSBERVNDLCAtLSBUcnkgdG8gZml0IGJpZyBsYWJlbHMgaW4gZmlyc3QNCiAgICAgICAg ICAgIG5hbWUgREVTQywgLS0gRm9yY2UgYSBjb25zaXN0ZW50IG9yZGVyaW5nIGJldHdlZW4gZGlm ZmVyZW50bHkKbmFtZWQgc3RyZWV0cw0KICAgICAgICAgICAgbC5vc21faWQgREVTQyAtLSBGb3Jj ZSBhbiBvcmRlcmluZyBmb3Igc3RyZWV0cyBvZiB0aGUgc2FtZSBuYW1lLAplLmcuIGR1YWxpemVk IHJvYWRzDQogICAgICAgICkgQVMgcm9hZHNfdGV4dF9uYW1lIFdIRVJFICJ3YXkiICYmClNUX1Nl dFNSSUQoJ0JPWDNEKDEyMjIzODAuOTU2MzM2NTM5IDYzMzkzODEuMzc3ODU5MzgsMTIzMzM4Ny44 ODg0MDk2MDQKNjM1MDM4OC4zMDk5MzI0NDQpJzo6Ym94M2QsIDM4NTcpDQoNCkkndmUgdXBsb2Fk ZWQgZGV0YWlsZWQgRVhQTEFJTkUgQU5BTFlaRSBvdXRwdXQgZm9yIGJvdGggc2NlbmFyaW9zOg0K DQpQb3N0Z3JlU1FMIDExLjQgKGV4ZWN1dGlvbiB0aW1lOiAxNDAuNW1zKQ0KaHR0cHM6Ly9leHBs YWluLmRlcGVzei5jb20vcy9Cc083DQoNClBvc3RncmVTUUwgMTIuMSAoZXhlY3V0aW9uIHRpbWU6 IDMzOTQuMm1zKQ0KaHR0cHM6Ly9leHBsYWluLmRlcGVzei5jb20vcy9UTUxPDQoNClRoZSBzZXR0 aW5ncy9oYXJkd2FyZSBvbiBib3RoIG1hY2hpbmVzIGlzIG5lYXJseSBpZGVudGljYWwuIFRoZSBv bmx5CmRpZmZlcmVuY2UgaXMgdGhlIGltcG9ydGVkIGRhdGEgdm9sdW1lIHdoaWNoIGlzIGhpZ2hl ciBmb3IgdGhlIDEyLjEKc2VydmVyKGV1cm9wZSB2cyBnZXJtYW55L2F1c3RyaWEvc3dpdHplcmxh bmQpIGJ1dCB0aGF0IHNob3VsZG4ndCBpbXBhY3QgdGhlCmhhc2ggam9pbiBwZXJmb3JtYW5jZSBh cyB0aGUgbnVtYmVyIG9mIHJvd3MgYXQgdGhpcyBwb2ludCBzaG91bGQgYmUgcm91Z2hseQp0aGUg c2FtZS4NCg0KVGhlIG9ubHkgY3VscHJpdCBzZWVtcyB0byBiZSB0aGF0IHRoZSBoYXNoIGpvaW4g dGFrZXMgYSBsb3QgbG9uZ2VyIHRvIGZpbmlzaAphbmQgaSBjYW4ndCBmaWd1cmUgb3V0IHdoeS4K Cg== --===============0493375972795982908==--