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 1t1MuD-00FxeV-QY for pgsql-committers@arkaria.postgresql.org; Thu, 17 Oct 2024 09:34:53 +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 1t1MuC-002Dl5-30 for pgsql-committers@arkaria.postgresql.org; Thu, 17 Oct 2024 09:34:52 +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 1t1MuB-002Dkv-RZ for pgsql-committers@lists.postgresql.org; Thu, 17 Oct 2024 09:34:52 +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 1t1Mu9-001KsM-E5 for pgsql-committers@lists.postgresql.org; Thu, 17 Oct 2024 09:34:50 +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=Hw7Exc6631RhNE0+77jP1vHg5/igxQgjUNTn9ePcb2E=; b=SKF3HMmSMzcDgYg+VWy5J+WMo2 q4kQumhTkbO1tJad6VtagAqdLnyF8GRooK3bfX0zY44E9+LtHuLGsbYIVCdxXT6YlJ5I78lbcjzjn mRsRf2SMdU5GvGuZs5+SDHMfFn/ryYqlji141DqAy8wv5Venh/m7lwipiYLsz6/NPGetp9k2bONUL bS+f25l4qgTwjENqGoRiNhvvxGpz0AlKx2NwQRw0O631bU5I/27Bl+R2Q+ZOwarra+xgVKotbJkuu WLvPd1Jbe3z+DZREZi9I45Exaa5dIscGAbQKTDUCLuZsECtD+zyJpPGMTn89ldhyNuw5atLj9nkjL 4CDfDraQ==; 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 1t1Mu8-004CVD-54 for pgsql-committers@lists.postgresql.org; Thu, 17 Oct 2024 09:34:48 +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 1t1Mu8-001DVi-UJ for pgsql-committers@lists.postgresql.org; Thu, 17 Oct 2024 09:34:48 +0000 Content-Type: multipart/mixed; boundary="===============6719231472079200386==" 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:48 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6719231472079200386== 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 Ml9TVEFCTEUKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9j b21taXRkaWZmLzRmYTgwYTZkN2Q0YmRlODMwNjVhNWUxZDg0YzAxNTIyZDJmZDM2OGMKCk1vZGlm aWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL25vZGVIYXNoLmMg fCAxNyArKysrKysrKysrKystLS0tLQoxIGZpbGUgY2hhbmdlZCwgMTIgaW5zZXJ0aW9ucygrKSwg NSBkZWxldGlvbnMoLSkKCg== --===============6719231472079200386==--