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 1t1Mu5-00Fxdm-Oz for pgsql-committers@arkaria.postgresql.org; Thu, 17 Oct 2024 09:34:45 +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 1t1Mu4-002DIS-2G for pgsql-committers@arkaria.postgresql.org; Thu, 17 Oct 2024 09:34:44 +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 1t1Mu3-002DIJ-Qz for pgsql-committers@lists.postgresql.org; Thu, 17 Oct 2024 09:34:44 +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.94.2) (envelope-from ) id 1t1Mtz-001Vec-BO for pgsql-committers@lists.postgresql.org; Thu, 17 Oct 2024 09:34:43 +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=zFmoEha/LUSANar1HuGhm3CpigJq4NVu4U6INoGDPB0=; b=twZ9Q29qTzW3rZyR610hWafgQ6 uYRunQ6gFw6rjGOtpZSTU2JDZlPE6Xe0BbpshdpWm9OLp9teZquz0uNMSXHZwL90wIxIzRFSSpNTr Xycad9/i0i2OXWi2waGqtfXMwZ/mNu4sH9NE0aFO+vCQiiv4w+BlCFihzyCAmhoZUWQEEafcPvAKh HTIPXrbLH5cUe2gUf2S3qacQAq5maYR+Myvt6oULFvTvSfVTVZJOOeEcTtM6DKrVr+DsEerP4wSec ZXlSmT6eQtyqOeZklFh4Ho59aWj1f5K5SGQ4zcf8C5wNvG/82slcUQV5gNoLGxSjzWaTBswrMm5Nn Ovkf8Exw==; 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 1t1Mtx-004CUu-A6 for pgsql-committers@lists.postgresql.org; Thu, 17 Oct 2024 09:34:38 +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 1t1Mty-001DV7-1Z for pgsql-committers@lists.postgresql.org; Thu, 17 Oct 2024 09:34:37 +0000 Content-Type: multipart/mixed; boundary="===============6621642700412770497==" 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:34:37 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6621642700412770497== 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 M19TVEFCTEUKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9j b21taXRkaWZmLzQ1MzI5NDY2ZmRjOTU1YjE2NmRlMTg2MjgxZjE5MWQwOWQzYTE2NjEKCk1vZGlm aWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL25vZGVIYXNoLmMg fCAxNyArKysrKysrKysrKystLS0tLQoxIGZpbGUgY2hhbmdlZCwgMTIgaW5zZXJ0aW9ucygrKSwg NSBkZWxldGlvbnMoLSkKCg== --===============6621642700412770497==--