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 1t1MtQ-00Fxa0-AY for pgsql-committers@arkaria.postgresql.org; Thu, 17 Oct 2024 09:34:04 +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 1t1MtO-002BDJ-Js for pgsql-committers@arkaria.postgresql.org; Thu, 17 Oct 2024 09:34:02 +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 1t1MtO-002BAx-Bq for pgsql-committers@lists.postgresql.org; Thu, 17 Oct 2024 09:34:02 +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 1t1MtI-001Kqi-UN for pgsql-committers@lists.postgresql.org; Thu, 17 Oct 2024 09:34:01 +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=k8kQ3mDeQwKwEQMG1dwfFSOL/JL0gftSdSPSRVzHzX4=; b=ec8i6iZgVvJsFkct4OEnTKvAWU EyPan/lJBdIa5RicLBJnEPR0/GNtpBKKTIMkQqxjRejVqDpkKg8GAb/guRnA+l17tc5D4YVk/ajvj NNqWfxSAO0nuMeS1GOR+R/1rCz6aO0uCm6VAPo87qqj1pkkp3qk9iSZaat44ce17x8WgpQxBKCh2v tEDQ6uRBGh6BbeGtie+jVK8LOOBTRZTlkDN+e/i21XggJd/u+4L9UpgJlIx+hPoO4u5WE5CJAmz0Z 7vUa9MkCVBeFpZ4wuO6VXSo1NVmUDQ0W2Upr8Uxv++9K/YxeYITALDhuvNuowvxT0bDCS+g5I2rTn YgqKsf/g==; 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 1t1MtH-004CTu-KI for pgsql-committers@lists.postgresql.org; Thu, 17 Oct 2024 09:33:56 +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 1t1MtI-001DTJ-Cu for pgsql-committers@lists.postgresql.org; Thu, 17 Oct 2024 09:33:55 +0000 Content-Type: multipart/mixed; boundary="===============4377490749569509898==" 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:55 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4377490749569509898== 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 Zm9RNGswREZlQjBRcWQtWC1yUSU0MG1haWwuZ21haWwuY29tCgpCcmFuY2gKLS0tLS0tClJFTF8x Nl9TVEFCTEUKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9j b21taXRkaWZmLzUzZWRjOTQ4NTgwZmYyZDJmZGJlMWIzNGVkMzlhZWZmYTYxZDY1NjQKCk1vZGlm aWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL25vZGVIYXNoLmMg fCAxNyArKysrKysrKysrKystLS0tLQoxIGZpbGUgY2hhbmdlZCwgMTIgaW5zZXJ0aW9ucygrKSwg NSBkZWxldGlvbnMoLSkKCg== --===============4377490749569509898==--