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 1v9r4F-009e2T-Ky for pgsql-committers@arkaria.postgresql.org; Fri, 17 Oct 2025 20:28:51 +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 1v9r4D-005A4j-O3 for pgsql-committers@arkaria.postgresql.org; Fri, 17 Oct 2025 20:28:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v9r4D-005A4b-FB for pgsql-committers@lists.postgresql.org; Fri, 17 Oct 2025 20:28:48 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1v9r4A-002mZx-0A for pgsql-committers@lists.postgresql.org; Fri, 17 Oct 2025 20:28:48 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=6K28l1PTq/C4yj1YBvoZUvSHRSTv1QjLq27kczXMIPA=; b=K7mm4u0s88cqcPsBdixa2MIUVo P7UgW1Wh0tkNYvOKBgeponU/MeSuJRidI+sjmborbmT0uvYP4leigod32eFvIJyd8Os4CYwKihyUN oSOidETZAxyi/l0LlVRsDUYjVnfBl/W8CW2JI+er3EIzU+tC5L+nUQ5FzxL8zEYI3BAmAK5Z1RVZs 2c8Nh0axzx8mS5vGb2gmPN74WEJ+kCL8a7QfaDGj42NX+Sktl8yfNfEW85wWUWye/Il14g8MrliMe w4izXJCcCnX+tM1DSoXel813xxdAoYMM5sqinVD//ndr3QkT6KA0X8jpavsmLAJzx2SSmLcPoNb56 3uQ7XYyQ==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v9r49-001abS-VO for pgsql-committers@lists.postgresql.org; Fri, 17 Oct 2025 20:28:44 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1v9r48-002Bvf-10 for pgsql-committers@lists.postgresql.org; Fri, 17 Oct 2025 20:28:44 +0000 Content-Type: multipart/mixed; boundary="===============3434434779595491930==" MIME-Version: 1.0 From: Tomas Vondra To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix hashjoin memory balancing logic X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 17 Oct 2025 20:28:44 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3434434779595491930== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IGhhc2hqb2luIG1lbW9yeSBiYWxhbmNpbmcgbG9naWMKCkNvbW1pdCBhMWI0ZjI4OWJlZWMg aW1wcm92ZWQgdGhlIGhhc2hqb2luIHNpemluZyB0byBhbHNvIGNvbnNpZGVyIHRoZQptZW1vcnkg dXNlZCBieSBCdWZGaWxlcyBmb3IgYmF0Y2hlcy4gVGhlIGNvZGUgaG93ZXZlciBoYWQgbXVsdGlw bGUKaXNzdWVzLCBtYWtpbmcgaXQgaW5lZmZlY3RpdmUgb3Igbm90IHdvcmtpbmcgYXMgZXhwZWN0 ZWQgaW4gc29tZSBjYXNlcy4KCiogVGhlIGFtb3VudCBvZiBtZW1vcnkgbmVlZGVkIGJ5IGJ1ZmZl cnMgd2FzIGNhbGN1bGF0ZWQgdXNpbmcgdWludDMyLAogIHNvIGl0IHdvdWxkIG92ZXJmbG93IGZv ciBuYmF0Y2ggPj0gMjYyMTQ0LiBJZiB0aGlzIGhhcHBlbmVkIHRoZSBsb29wCiAgd291bGQgZXhp dCBwcmVtYXR1cmVseSBhbmQgdGhlIG1lbW9yeSB1c2FnZSB3b3VsZCBub3QgYmUgcmVkdWNlZC4K CiAgVGhlIG5iYXRjaCBvdmVyZmxvdyBpcyBmaXhlZCBieSByZXdvcmtpbmcgdGhlIGNvbmRpdGlv biB0byBub3QgdXNlIGEKICBtdWx0aXBsaWNhdGlvbiBhdCBhbGwsIHNvIHRoZXJlJ3Mgbm8gcmlz ayBvZiBvdmVyZmxvdy4gQW4gZXhwbGljaXQKICBjYXN0IHdhcyBhZGRlZCB0byBhIHNpbWlsYXIg Y2FsY3VsYXRpb24gaW4gRXhlY0hhc2hJbmNyZWFzZUJhdGNoU2l6ZS4KCiogVGhlIGxvb3AgYWRq dXN0aW5nIHRoZSBuYmF0Y2ggdmFsdWUgdXNlZCBoYXNoX3RhYmxlX2J5dGVzIHRvIGNhbGN1bGF0 ZQogIHRoZSBvbGQvbmV3IHNpemUsIGJ1dCB0aGVuIHVwZGF0ZWQgb25seSBzcGFjZV9hbGxvd2Vk LiBUaGUgY29uc2VxdWVuY2UKICBpcyB0aGUgdG90YWwgbWVtb3J5IHVzYWdlIHdhcyBub3QgcmVk dWNlZCwgYnV0IGFsbCB0aGUgbWVtb3J5IHNhdmVkIGJ5CiAgcmVkdWNpbmcgdGhlIG51bWJlciBv ZiBiYXRjaGVzIHdhcyB1c2VkIGZvciB0aGUgaW50ZXJuYWwgaGFzaCB0YWJsZS4KCiAgVGhpcyB3 YXMgZml4ZWQgYnkgdXNpbmcgb25seSBzcGFjZV9hbGxvd2VkLiBUaGlzIGlzIGFsc28gbW9yZSBj b3JyZWN0LAogIGJlY2F1c2UgaGFzaF90YWJsZV9ieXRlcyBkb2VzIG5vdCBhY2NvdW50IGZvciBz a2V3IGJ1Y2tldHMuCgoqIFRoZSBjb2RlIHdhcyBhbHNvIGRvdWJsaW5nIG11bHRpcGxlIHBhcmFt ZXRlcnMgKGUuZy4gdGhlIG51bWJlciBvZgogIGJ1Y2tldHMgZm9yIGhhc2ggdGFibGUpLCBidXQg d2FzIG1pc3Npbmcgb3ZlcmZsb3cgcHJvdGVjdGlvbnMuCgogIFRoZSBsb29wIG5vdyBjaGVja3Mg Zm9yIG92ZXJmbG93LCBhbmQgdGVybWluYXRlcyBpZiBuZWVkZWQuIEl0J2QgYmUKICBwb3NzaWJs ZSB0byBjYXAgdGhlIHZhbHVlIGFuZCBjb250aW51ZSB0aGUgbG9vcCwgYnV0IGl0J3Mgbm90IHdv cnRoCiAgdGhlIGNvbXBsZXhpdHkuIEFuZCB0aGUgb3ZlcmZsb3cgaW1wbGllcyB0aGUgaW4tbWVt b3J5IGhhc2ggdGFibGUgaXMKICBhbHJlYWR5IHZlcnkgbGFyZ2UgYW55d2F5LgoKV2hpbGUgYXQg aXQsIHJld29yayB0aGUgY29tbWVudCBleHBsYWluaW5nIGhvdyB0aGUgbWVtb3J5IGJhbGFuY2lu Zwp3b3JrcywgdG8gbWFrZSBpdCBtb3JlIGNvbmNpc2UgYW5kIGVhc2llciB0byB1bmRlcnN0YW5k LgoKVGhlIGluaXRpYWwgbmJhdGNoIG92ZXJmbG93IGlzc3VlIHdhcyByZXBvcnRlZCBieSBWYWli aGF2IEphaW4uIFRoZQpvdGhlciBpc3N1ZXMgd2VyZSBub3RpY2VkIGJ5IG1lIGFuZCBNZWxhbmll IFBsYWdlbWFuLiBGaXggYnkgbWUsIHdpdGggYQpsb3Qgb2YgcmV2aWV3IGFuZCBmZWVkYmFjayBi eSBNZWxhbmllLgoKQmFja3BhdGNoIHRvIDE4LCB3aGVyZSB0aGUgaGFzaGpvaW4gbWVtb3J5IGJh bGFuY2luZyB3YXMgaW50cm9kdWNlZC4KClJlcG9ydGVkLWJ5OiBWYWliaGF2IEphaW4gPGphaW52 YUBnb29nbGUuY29tPgpSZXZpZXdlZC1ieTogTWVsYW5pZSBQbGFnZW1hbiA8bWVsYW5pZXBsYWdl bWFuQGdtYWlsLmNvbT4KQmFja3BhdGNoLXRocm91Z2g6IDE4CkRpc2N1c3Npb246IGh0dHBzOi8v cG9zdGdyLmVzL20vQ0FCYS1BejE3NFl2ZkZxN3JMUytWTkthUXlnN2luQTJleHZQV21QV3FuRW42 RGl0cl9RQG1haWwuZ21haWwuY29tCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0t LS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvYjg1YzQ3MDBmYzUx MjQ5OTllMjJlYTczMDBlY2MwYTI5MGM4MWNiYwoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0t LS0Kc3JjL2JhY2tlbmQvZXhlY3V0b3Ivbm9kZUhhc2guYyB8IDEyMiArKysrKysrKysrKysrKysr KysrKystLS0tLS0tLS0tLS0tLS0tLS0tCjEgZmlsZSBjaGFuZ2VkLCA2NCBpbnNlcnRpb25zKCsp LCA1OCBkZWxldGlvbnMoLSkKCg== --===============3434434779595491930==--