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 1pi127-0006YF-G1 for pgsql-committers@arkaria.postgresql.org; Thu, 30 Mar 2023 22:46:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pi124-0005SH-KO for pgsql-committers@arkaria.postgresql.org; Thu, 30 Mar 2023 22:46:12 +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 1pi124-0005S8-71 for pgsql-committers@lists.postgresql.org; Thu, 30 Mar 2023 22:46:12 +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 1pi11y-0007zC-Jd for pgsql-committers@lists.postgresql.org; Thu, 30 Mar 2023 22:46:11 +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=cyy7ni+3jxSYeSLrjeZkOCzVEUsTRAoec8EWNIOvAEo=; b=dpeUjh7vGwt4aZCltV+PFOPevg ulqN5/nqS48tZLQABsXvNwJRMHe/yCIv9TCm/pAU29UGXVby8R7WKmfGjWHSqrsOgcLnhFfkqBI/U sg9h7Dx8+yZbiv/mBZKBenT4IfPYpZ+khdmJLxo868s91CNcxCgoknGahYlsBvVZxgDSTUIF3Xq1w AhnDsMHOXVPYjBg6sqIYaw80CIwFELJbaQosZZ4HcJqN7Ym0YqYksW229F9H+y4S9Hpe4V/2eJIfi WiRBbce7pNoOEgEAnAY6R0ZCkGytsJhICpDAkN0oFdI+jBnqHmvsRMdFfg/NwAR+jU45YEZvpiqP7 Hu0juUdg==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pi11y-0003aQ-3T for pgsql-committers@lists.postgresql.org; Thu, 30 Mar 2023 22:46:06 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pi11w-000XW9-0X for pgsql-committers@lists.postgresql.org; Thu, 30 Mar 2023 22:46:05 +0000 Content-Type: multipart/mixed; boundary="===============5170163614814079660==" MIME-Version: 1.0 From: Thomas Munro To: pgsql-committers@lists.postgresql.org Subject: pgsql: Parallel Hash Full Join. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 30 Mar 2023 22:46:05 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5170163614814079660== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UGFyYWxsZWwgSGFzaCBGdWxsIEpvaW4uCgpGdWxsIGFuZCByaWdodCBvdXRlciBqb2lucyB3ZXJl IG5vdCBzdXBwb3J0ZWQgaW4gdGhlIGluaXRpYWwKaW1wbGVtZW50YXRpb24gb2YgUGFyYWxsZWwg SGFzaCBKb2luIGJlY2F1c2Ugb2YgZGVhZGxvY2sgaGF6YXJkcyAoc2VlCmRpc2N1c3Npb24pLiAg VGhlcmVmb3JlIEZVTEwgSk9JTiBpbmhpYml0ZWQgcGFyYWxsZWxpc20sIGFzIHRoZSBvdGhlcgpq b2luIHN0cmF0ZWdpZXMgY2FuJ3QgZG8gdGhhdCBpbiBwYXJhbGxlbCBlaXRoZXIuCgpBZGQgYSBu ZXcgUEhKIHBoYXNlIFBISl9CQVRDSF9TQ0FOIHRoYXQgc2NhbnMgZm9yIHVubWF0Y2hlZCB0dXBs ZXMgb24KdGhlIGlubmVyIHNpZGUgb2Ygb25lIGJhdGNoJ3MgaGFzaCB0YWJsZS4gIEZvciBub3cs IHNpZGVzdGVwIHRoZQpkZWFkbG9jayBwcm9ibGVtIGJ5IHRlcm1pbmF0aW5nIHBhcmFsbGVsaXNt IHRoZXJlLiAgVGhlIGxhc3QgcHJvY2VzcyB0bwphcnJpdmUgYXQgdGhhdCBwaGFzZSBlbWl0cyB0 aGUgdW5tYXRjaGVkIHR1cGxlcywgd2hpbGUgb3RoZXJzIGRldGFjaCBhbmQKYXJlIGZyZWUgdG8g Z28gYW5kIHdvcmsgb24gb3RoZXIgYmF0Y2hlcywgaWYgdGhlcmUgYXJlIGFueSwgYnV0Cm90aGVy d2lzZSB0aGV5IGZpbmlzaCB0aGUgam9pbiBlYXJseS4KClRoYXQgdW5mYWlybmVzcyBpcyBjb25z aWRlcmVkIGFjY2VwdGFibGUgZm9yIG5vdywgYmVjYXVzZSBpdCdzIGJldHRlcgp0aGFuIG5vIHBh cmFsbGVsaXNtIGF0IGFsbC4gIFRoZSBidWlsZCBhbmQgcHJvYmUgcGhhc2VzIGFyZSBydW4gaW4K cGFyYWxsZWwsIGFuZCB0aGUgbmV3IHNjYW4tZm9yLXVubWF0Y2hlZCBwaGFzZSwgd2hpbGUgc2Vy aWFsLCBpcyB1c3VhbGx5CmFwcGxpZWQgdG8gdGhlIHNtYWxsZXIgb2YgdGhlIHR3byByZWxhdGlv bnMgYW5kIGlzIGVpdGhlciBsaW1pdGVkIGJ5CnNvbWUgbXVsdGlwbGUgb2Ygd29ya19tZW0sIG9y IGl0J3MgdG9vIGJpZyBhbmQgaXMgcGFydGl0aW9uZWQgaW50bwpiYXRjaGVzIGFuZCB0aGVuIHRo ZSBzaXR1YXRpb24gaXMgaW1wcm92ZWQgYnkgYmF0Y2gtbGV2ZWwgcGFyYWxsZWxpc20uCgpBdXRo b3I6IE1lbGFuaWUgUGxhZ2VtYW4gPG1lbGFuaWVwbGFnZW1hbkBnbWFpbC5jb20+CkF1dGhvcjog VGhvbWFzIE11bnJvIDx0aG9tYXMubXVucm9AZ21haWwuY29tPgpSZXZpZXdlZC1ieTogVGhvbWFz IE11bnJvIDx0aG9tYXMubXVucm9AZ21haWwuY29tPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rn ci5lcy9tL0NBJTJCaFVLRyUyQkE2ZnRYUHo0b2U5MiUyQng4RXIlMkJ4cEdacXRvNzAtUV9FUndS YVN5QSUzRGFmTmclNDBtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFp bHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzExYzJk NmZkZjVhZjFhYWNlYzljYTIwMDU1NDNmMWIwZmM0Y2MzNjQKCk1vZGlmaWVkIEZpbGVzCi0tLS0t LS0tLS0tLS0tCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL25vZGVIYXNoLmMgICAgICAgICB8IDE3NSAr KysrKysrKysrKysrKysrKysrKysrKysrKysrKysrLQpzcmMvYmFja2VuZC9leGVjdXRvci9ub2Rl SGFzaGpvaW4uYyAgICAgfCAgODEgKysrKysrKysrKy0tLS0tCnNyYy9iYWNrZW5kL29wdGltaXpl ci9wYXRoL2pvaW5wYXRoLmMgICB8ICAxNCArKy0Kc3JjL2luY2x1ZGUvZXhlY3V0b3IvaGFzaGpv aW4uaCAgICAgICAgIHwgICA2ICstCnNyYy9pbmNsdWRlL2V4ZWN1dG9yL25vZGVIYXNoLmggICAg ICAgICB8ICAgMyArCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvam9pbl9oYXNoLm91dCB8ICA2 NSArKysrKysrKysrKy0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvam9pbl9oYXNoLnNxbCAgICAgIHwg IDI3ICsrKystCjcgZmlsZXMgY2hhbmdlZCwgMzIzIGluc2VydGlvbnMoKyksIDQ4IGRlbGV0aW9u cygtKQoK --===============5170163614814079660==--