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 1t1Mt2-00FxXh-Tt for pgsql-committers@arkaria.postgresql.org; Thu, 17 Oct 2024 09:33:41 +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 1t1Msz-0029vp-HM for pgsql-committers@arkaria.postgresql.org; Thu, 17 Oct 2024 09:33:37 +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 1t1Msz-0029vO-9L for pgsql-committers@lists.postgresql.org; Thu, 17 Oct 2024 09:33:37 +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 1t1Mst-001KqH-LK for pgsql-committers@lists.postgresql.org; Thu, 17 Oct 2024 09:33:36 +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=xsb1lXHZzp6N4RATOar1QICoiOwHiGGqYf+2tyAcNAY=; b=tn1S8sk39hbVMoke/gOj+dh42Q OqgraOT7aZHr8tml/8ObKyN+JQ8uHDNXBiEHWvKzGLxxFLaTxNnR48WEgO/XePHoWrW/2TAZRs41b oGE9KNHiEkyCeXxcuC3IYT026CVO/YFd6BeksSTVXp+FCaJojBDQy4UI6VKK+0Ajf2UU823594r0F OU4V0bS7dxGiF1DVsveU3+OWPZYLA+dDmrIl4GKL579bV3Re1kl7eY57plAYhgSH+rcOWOlhOXEVE RRPWuPbaqz9fgVhosCdblZSYoXhrt1AVsnbqCCIrCvPs0Z6TR2jSSUEsqN+hdHWE1hBAWy5Ao2kZr R6hZTZog==; 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 1t1Mss-004CSa-D6 for pgsql-committers@lists.postgresql.org; Thu, 17 Oct 2024 09:33:31 +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 1t1Mst-001DS5-5x for pgsql-committers@lists.postgresql.org; Thu, 17 Oct 2024 09:33:30 +0000 Content-Type: multipart/mixed; boundary="===============3999322039883322072==" MIME-Version: 1.0 From: Thomas Munro To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix extreme skew detection in Parallel Hash Join. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 17 Oct 2024 09:33:30 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3999322039883322072== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IGV4dHJlbWUgc2tldyBkZXRlY3Rpb24gaW4gUGFyYWxsZWwgSGFzaCBKb2luLgoKQWZ0ZXIg cmVwYXJ0aXRpb25pbmcgdGhlIGlubmVyIHNpZGUgb2YgYSBoYXNoIGpvaW4gdGhhdCB3b3VsZCBo YXZlCmV4Y2VlZGVkIHRoZSBhbGxvd2VkIHNpemUsIHdlIGNoZWNrIGlmIGFsbCB0aGUgdHVwbGVz IGZyb20gYSBwYXJlbnQKcGFydGl0aW9uIG1vdmVkIHRvIG9uZSBjaGlsZCBwYXJ0aXRpb24uICBU aGF0IGlzIGV2aWRlbmNlIHRoYXQgaXQKY29udGFpbnMgZHVwbGljYXRlIGtleXMgYW5kIGxhdGVy IGF0dGVtcHRzIHRvIHJlcGFydGl0aW9uIHdpbGwgYWxzbwpmYWlsLCBzbyB3ZSBzaG91bGQgZ2l2 ZSB1cCB0cnlpbmcgdG8gbGltaXQgbWVtb3J5IChmb3IgbGFjayBvZiBhIGJldHRlcgpmYWxsYmFj ayBzdHJhdGVneSkuCgpBIHRoaW5rbyBwcmV2ZW50ZWQgdGhlIGNoZWNrIGZyb20gd29ya2luZyBj b3JyZWN0bHkgaW4gcGFydGl0aW9uIDAgKHRoZQpvbmUgdGhhdCBpcyBwYXJ0aWFsbHkgbG9hZGVk IGludG8gbWVtb3J5IGFscmVhZHkpLiAgQWZ0ZXIKcmVwYXJ0aXRpb25pbmcsIHdlIHNob3VsZCBj aGVjayBmb3IgZXh0cmVtZSBza2V3IGlmIHRoZSAqcGFyZW50KgpwYXJ0aXRpb24ncyBzcGFjZV9l eGhhdXN0ZWQgZmxhZyB3YXMgc2V0LCBub3QgdGhlIGNoaWxkIHBhcnRpdGlvbidzLgpUaGUgY29u c2VxdWVuY2Ugd2FzIHJlcGVhdGVkIGZ1dGlsZSByZXBhcnRpdGlvbmluZyB1bnRpbCBwZXItcGFy dGl0aW9uCmRhdGEgZXhjZWVkZWQgdmFyaW91cyBsaW1pdHMgaW5jbHVkaW5nICJFUlJPUjogaW52 YWxpZCBEU0EgbWVtb3J5IGFsbG9jCnJlcXVlc3Qgc2l6ZSAxODExOTM5MzI4IiwgT1MgYWxsb2Nh dGlvbiBmYWlsdXJlLCBvciB0ZW1wb3JhcnkgZGlzayBzcGFjZQplcnJvcnMuICAoV2UgY291bGQg YWxzbyBkbyBzb21ldGhpbmcgYWJvdXQgc29tZSBvZiB0aG9zZSBzeW1wdG9tcywgYnV0CnRoYXQn cyBtYXRlcmlhbCBmb3Igc2VwYXJhdGUgcGF0Y2hlcy4pCgpUaGlzIHByb2JsZW0gb25seSBiZWNh bWUgbGlrZWx5IHdoZW4gUG9zdGdyZVNRTCAxNiBpbnRyb2R1Y2VkIHN1cHBvcnQKZm9yIFBhcmFs bGVsIEhhc2ggUmlnaHQvRnVsbCBKb2luLCBhbGxvd2luZyBOVUxMIGtleXMgaW50byB0aGUgaGFz aAp0YWJsZS4gIFJlcGFydGl0aW9uaW5nIGFsd2F5cyBsZWF2ZXMgTlVMTCBpbiBwYXJ0aXRpb24g MCwgbm8gbWF0dGVyIGhvdwptYW55IHRpbWVzIHlvdSBkbyBpdCwgYmVjYXVzZSB0aGUgaGFzaCB2 YWx1ZSBpcyBhbGwgemVybyBiaXRzLiAgVGhhdCdzCnVubGlrZWx5IGZvciBvdGhlciBoYXNoZWQg dmFsdWVzLCBidXQgdGhleSBtaWdodCBzdGlsbCBoYXZlIGNhdXNlZAp3YXN0ZWQgZXh0cmEgZWZm b3J0IGJlZm9yZSBnaXZpbmcgdXAuCgpCYWNrLXBhdGNoIHRvIGFsbCBzdXBwb3J0ZWQgcmVsZWFz ZXMuCgpSZXBvcnRlZC1ieTogQ3JhaWcgTWlsaGlzZXIgPGNyYWlnQG1pbGhpc2VyLmNvbT4KUmV2 aWV3ZWQtYnk6IEFuZHJlaSBMZXBpa2hvdiA8bGVwaWhvdkBnbWFpbC5jb20+CkRpc2N1c3Npb246 IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0ElMkJ3bmhPMU9mZ1hibVhnQzRmdl91dSUzRE94Y0RRdUh2 Zm9RNGswREZlQjBRcWQtWC1yUSU0MG1haWwuZ21haWwuY29tCgpCcmFuY2gKLS0tLS0tCm1hc3Rl cgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRp ZmYvOThjN2M3MTUyZDJkNDY3MGEzNDljMGZlNDhmMDVjZjk1YzBiMTE4NQoKTW9kaWZpZWQgRmls ZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvZXhlY3V0b3Ivbm9kZUhhc2guYyB8IDE3ICsr KysrKysrKysrKy0tLS0tCjEgZmlsZSBjaGFuZ2VkLCAxMiBpbnNlcnRpb25zKCspLCA1IGRlbGV0 aW9ucygtKQoK --===============3999322039883322072==--