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 1rppaB-008sKE-Lj for pgsql-bugs@arkaria.postgresql.org; Thu, 28 Mar 2024 13:14:16 +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 1rppaA-00DvkN-Nk for pgsql-bugs@arkaria.postgresql.org; Thu, 28 Mar 2024 13:14:14 +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 1rppEn-00DWUZ-33 for pgsql-bugs@lists.postgresql.org; Thu, 28 Mar 2024 12:52: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.94.2) (envelope-from ) id 1rppEh-006seF-N0 for pgsql-bugs@lists.postgresql.org; Thu, 28 Mar 2024 12:52:07 +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=qGsQ8EMwoifOPyiCdOk/Sd1HAIm0njdr8FsMh6iN6p8=; b=fV1qWnq1cMGvqyTfOlBYdINbwB TB98HuIsJ+3wxyGkQ8zo+a8HY3qmYPnampsc08df1cqMC4AXBp3zkvMUM6Ofq3SFKwN/p+h6YIv5Z r1R4U/NRBtOqUUj/KPYBCe6yHzcf/dSi5ShDWwPk1NFQOawWtsVw+syZCfGx38YIZhBrsAngqovN6 Ah2kVcjFrQLm5Blj5gIlzx72zGuKhX0a9O4jUeztCrr39ACd4j+4ip4E+UvTcIMxeYwjoKxLATBPH fsxZ2PhZ2d+ajGG6f7HuZMAZsa8ZZbI8rL6ZEN6WNpkspXxo2ZOYsJlKDaPN8Tzja32b/OCUYwKFP 6av3XByw==; 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 1rppEi-001ZKv-6i for pgsql-bugs@lists.postgresql.org; Thu, 28 Mar 2024 12:52:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rppEf-00Awon-F2 for pgsql-bugs@lists.postgresql.org; Thu, 28 Mar 2024 12:52:02 +0000 Content-Type: multipart/mixed; boundary="===============6102172124191813346==" MIME-Version: 1.0 Subject: BUG #18414: When the key values are the same, the memory limit is exceeded when making a hash join To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: 723609220apple@gmail.com Reply-To: 723609220apple@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 28 Mar 2024 12:51:15 +0000 Message-ID: <18414-6ace9250aab89519@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 --===============6102172124191813346== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODQxNApMb2dnZWQgYnk6ICAgICAgICAgIGxpbmZlbmcgY2hlbgpFbWFp bCBhZGRyZXNzOiAgICAgIDcyMzYwOTIyMGFwcGxlQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNp b246IDE2LjIKT3BlcmF0aW5nIHN5c3RlbTogICBvcGVuZXVsZXIKRGVzY3JpcHRpb246ICAgICAg ICAKCi8qDQoJCQkJCQkgKiBEaWQgdGhpcyBiYXRjaCByZWNlaXZlIEFMTCBvZiB0aGUgdHVwbGVz IGZyb20gaXRzDQoJCQkJCQkgKiBwYXJlbnQgYmF0Y2g/ICBUaGF0IHdvdWxkIGluZGljYXRlIHRo YXQgZnVydGhlcg0KCQkJCQkJICogcmVwYXJ0aXRpb25pbmcgaXNuJ3QgZ29pbmcgdG8gaGVscCAo dGhlIGhhc2ggdmFsdWVzDQoJCQkJCQkgKiBhcmUgcHJvYmFibHkgYWxsIHRoZSBzYW1lKS4NCgkJ CQkJCSAqLw0KY3JlYXRlIHRhYmxlIHQxKGEgaW50KTsNCmNyZWF0ZSB0YWJsZSB0MihhIGludCk7 DQppbnNlcnQgaW50byB0MSB2YWx1ZXMoMSk7DQppbnNlcnQgaW50byB0MSBzZWxlY3QgKiBmcm9t IHQxOw0KaW5zZXJ0IGludG8gdDEgc2VsZWN0ICogZnJvbSB0MTsNCmluc2VydCBpbnRvIHQxIHNl bGVjdCAqIGZyb20gdDE7DQppbnNlcnQgaW50byB0MSBzZWxlY3QgKiBmcm9tIHQxOw0KaW5zZXJ0 IGludG8gdDEgc2VsZWN0ICogZnJvbSB0MTsNCmluc2VydCBpbnRvIHQxIHNlbGVjdCAqIGZyb20g dDE7DQppbnNlcnQgaW50byB0MSBzZWxlY3QgKiBmcm9tIHQxOw0KaW5zZXJ0IGludG8gdDEgc2Vs ZWN0ICogZnJvbSB0MTsNCmluc2VydCBpbnRvIHQxIHNlbGVjdCAqIGZyb20gdDE7DQppbnNlcnQg aW50byB0MSBzZWxlY3QgKiBmcm9tIHQxOw0KaW5zZXJ0IGludG8gdDEgc2VsZWN0ICogZnJvbSB0 MTsNCmluc2VydCBpbnRvIHQxIHNlbGVjdCAqIGZyb20gdDE7DQppbnNlcnQgaW50byB0MSBzZWxl Y3QgKiBmcm9tIHQxOw0KaW5zZXJ0IGludG8gdDEgc2VsZWN0ICogZnJvbSB0MTsNCmluc2VydCBp bnRvIHQxIHNlbGVjdCAqIGZyb20gdDE7DQppbnNlcnQgaW50byB0MSBzZWxlY3QgKiBmcm9tIHQx Ow0KaW5zZXJ0IGludG8gdDIgc2VsZWN0ICogZnJvbSB0MTsNCnNlbGVjdCBjb3VudCgqKSBmcm9t IHQxIGpvaW4gdDIgb24gdDEuYT10Mi5hOwoK --===============6102172124191813346==--