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 1upw2N-00Eeij-PK for pgsql-bugs@arkaria.postgresql.org; Sat, 23 Aug 2025 21:44:37 +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 1upw2N-00Gqzv-5f for pgsql-bugs@arkaria.postgresql.org; Sat, 23 Aug 2025 21:44:35 +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 1upqD0-00FWBp-CP for pgsql-bugs@lists.postgresql.org; Sat, 23 Aug 2025 15:31:11 +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 1upqCu-001Mwl-2h for pgsql-bugs@lists.postgresql.org; Sat, 23 Aug 2025 15:31:09 +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=aaMBHQSY+5Bmpk2d2W1OBqvmMfQOVdA26YzpqyT8Bi4=; b=OXibto7BDpizAt16WsJuGLhiRq Xcjm2qmUaOOqHD83xnSwcFXSKZrrjIupg9qx/GZ8CEv0TY/1eO6XZWUoScYfWgGqyuz2IwZQ/5a/Q +vZZiD1V4t+z/WlB1ZQh3TLcLAamMUb2rJ0SKWpWiiRz/Q+lytHSEuOyztOzQlcAMaRSZ/1+jQyf/ Ux4Co1A/zLmAzlUuBCyaRikEni5YWc5g56wxcEYiXTzO4bsyg91BjzUg/M3un2SSdZAbRNuBDJF7c U6PxQWZX9mpX1fZAlzlHoVkLL0FZWsGHhWSX84BaPKW8ClUS7qR6twRPK3CQoupc5lPlJOUghD3DY eSA0sMkg==; 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 1upqCu-003l9L-Qq for pgsql-bugs@lists.postgresql.org; Sat, 23 Aug 2025 15:31:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1upqCt-008IyJ-0d for pgsql-bugs@lists.postgresql.org; Sat, 23 Aug 2025 15:31:03 +0000 Content-Type: multipart/mixed; boundary="===============1079526097312028727==" MIME-Version: 1.0 Subject: BUG #19030: Hash join leads to extremely high memory usage To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: moj@dshare.de Reply-To: moj@dshare.de, pgsql-bugs@lists.postgresql.org Date: Sat, 23 Aug 2025 15:30:13 +0000 Message-ID: <19030-944dd78d7ef94c0f@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 --===============1079526097312028727== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTAzMApMb2dnZWQgYnk6ICAgICAgICAgIE1hcmMtT2xhZiBKYXNjaGtl CkVtYWlsIGFkZHJlc3M6ICAgICAgbW9qQGRzaGFyZS5kZQpQb3N0Z3JlU1FMIHZlcnNpb246IDE3 LjYKT3BlcmF0aW5nIHN5c3RlbTogICBMaW51eApEZXNjcmlwdGlvbjogICAgICAgIAoKRGVzY3Jp cHRpb24KLSBUd28gdGFibGVzLCBsZWZ0IGpvaW4KLSBUaGUgbGVmdCB0YWJsZSBoYXMgc2lnbmlm aWNhbnRseSBmZXdlciByb3dzIHRoYW4gdGhlIHJpZ2h0IHRhYmxlCi0gVGhlIGxlZnQgdGFibGUg aGFzIHZlcnkgbGFyZ2Ugcm93cyAobWFueSBjb2x1bW5zIHdpdGggaGlnaCBtZW1vcnkgdXNhZ2Up Ci0gVGhlIGxlZnQgdGFibGUgaGFzIG1hbnkgbnVsbCB2YWx1ZXMgaW4gdGhlIGpvaW4gY29sdW1u Ci0gQSBoYXNoIGpvaW4gaXMgdXNlZAotIFRoZSBoYXNoIG5vZGUgaXMgYnVpbHQgZnJvbSB0aGUg bGVmdCB0YWJsZQotIFRoZSBxdWVyeSByZXN1bHRzIGluIGV4dHJlbWVseSBoaWdoIG1lbW9yeSB1 c2FnZSAoMTAweCB3b3JrX21lbSBpbiB0aGUKZXhhbXBsZSwgPiAxMDAweCBpbiByZWFsIGNhc2Up Ci0gUmVsaWFibHkgY2F1c2luZyBhIFBvc3RncmVTUUwgc2VydmVyIHRvIGNyYXNoIGluIHByb2R1 Y3Rpb24KLSBXaXRoIGVuYWJsZV9oYXNoam9pbiA9IGZhbHNlLCB0aGUgcXVlcnkgcnVucyB3aXRo b3V0IGFueSBpc3N1ZXMKCkV4YW1wbGUKLSBTaW1wbGlmaWVkIGFydGlmaWNpYWwgZXhhbXBsZSDi gJMgYnV0IEkgaG9wZSBpdCBzaW11bGF0ZXMgYSByZWFsIHByb2JsZW0gb24KYSBwcm9kdWN0aW9u IHN5c3RlbSB3ZWxsLgotIFNpbXVsYXRlIGxhcmdlIHJvd3Mgd2l0aCBvbmUgYmlnIGNvbHVtbgot IFJ1bm5pbmcgdGhlIG5ld2VzdCB2ZXJzaW9uIHdpdGggbW9zdGx5IGRlZmF1bHQgc2V0dGluZ3MK Cgo9PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT0KCgpzZWxlY3QgdmVy c2lvbigpOwotLSA+IFBvc3RncmVTUUwgMTcuNiAoRGViaWFuIDE3LjYtMS5wZ2RnMTMrMSkgb24g YWFyY2g2NC11bmtub3duLWxpbnV4LWdudSwKY29tcGlsZWQgYnkgZ2NjIChEZWJpYW4gMTQuMi4w LTE5KSAxNC4yLjAsIDY0LWJpdAoKc2hvdyB3b3JrX21lbTsKLS0gPiA0TUIKCnNob3cgaGFzaF9t ZW1fbXVsdGlwbGllcjsKLS0gPiAyCgotLSBzcGVlZCB1cCB0aGUgdGVzdCBjYXNlCnNldCBkZWZh dWx0X3RvYXN0X2NvbXByZXNzaW9uID0gbHo0OwoKLS0gc2hvdyBoaWdoIG1lbW9yeSB1c2FnZSB3 aXRob3V0IGNyYXNoaW5nIHRoZSBzZXJ2ZXIKc2V0IG1heF9wYXJhbGxlbF93b3JrZXJzX3Blcl9n YXRoZXIgPSAwOwoKCmNyZWF0ZSB0YWJsZSBsZWZ0XyBhcwpzZWxlY3QKY2FzZSB3aGVuIGklIDIg PSAwIHRoZW4gaTo6dGV4dCBlbmQgYywKcmVwZWF0KCd4JywgMTBfMDAwKSBiaWcKZnJvbQpnZW5l cmF0ZV9zZXJpZXMoMSwgMTBfMDAwXzAwMCkgaTsKCmNyZWF0ZSB0YWJsZSByaWdodF8gYXMKc2Vs ZWN0CmNhc2Ugd2hlbiBpJSAyID0gMCB0aGVuIGk6OnRleHQgZW5kIGMKZnJvbQpnZW5lcmF0ZV9z ZXJpZXMoMSwgMjBfMDAwXzAwMCkgaTsKCmFuYWx5emUgbGVmdF8sIHJpZ2h0XzsKCgpleHBsYWlu IChhbmFseXplLCBtZW1vcnkpCnNlbGVjdAoqCmZyb20KbGVmdF8KbmF0dXJhbCBsZWZ0IGpvaW4K cmlnaHRfOwoKLS0gPiBCdWNrZXRzOiAxMzEwNzIgKG9yaWdpbmFsbHkgMTMxMDcyKSAgQmF0Y2hl czogMTMxMDcyIChvcmlnaW5hbGx5IDI1NikKTWVtb3J5IFVzYWdlOiA0NDA0ODJrQgoK --===============1079526097312028727==--