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 1sgDqK-00GweB-2S for pgsql-committers@arkaria.postgresql.org; Tue, 20 Aug 2024 01:39:28 +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 1sgDqI-005yTB-3e for pgsql-committers@arkaria.postgresql.org; Tue, 20 Aug 2024 01:39:26 +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 1sgDqH-005yT3-P0 for pgsql-committers@lists.postgresql.org; Tue, 20 Aug 2024 01:39:26 +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 1sgDqD-000XBw-JL for pgsql-committers@lists.postgresql.org; Tue, 20 Aug 2024 01:39:25 +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=pNxDx5G5VV29aZI/pi74azF7Rxg48QoreBNAgytuyNc=; b=NX8zxe9dNsT1LA2Sw7W49ucWwx L4Djogw6u+OG1hs3cg1NmwHqRN5P/lL8ZpK0D6Zbh99hYPB18IeaHREVqv2MdodOfZYrcyOoq/xGs z955MittJas6yLbTtmm2/zEL6yENCxJjWMKDSmrCWYe5zM4GiNGvumBN09nL7tmmKnvGcb+W41x29 16A2PNeE939FBk1R2I1LI0hw2dTM9chP0ix81L76OJIG/OQa89RKsNIDIjSdji9vFXwkLmC8ugeDg 5czDdRaB8IcIMT3SfrxZaP3MaDpmfX495oLVlwwOSDfG8w2QwqpYkDZ2SL8A365xPmO6wqRdfNIYO M0c0M1bQ==; 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 1sgDqC-001cTg-KB for pgsql-committers@lists.postgresql.org; Tue, 20 Aug 2024 01:39:21 +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 1sgDqB-000W0s-Us for pgsql-committers@lists.postgresql.org; Tue, 20 Aug 2024 01:39:20 +0000 Content-Type: multipart/mixed; boundary="===============6428464342674129031==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Speed up Hash Join by making ExprStates support hashing X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 20 Aug 2024 01:39:20 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6428464342674129031== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U3BlZWQgdXAgSGFzaCBKb2luIGJ5IG1ha2luZyBFeHByU3RhdGVzIHN1cHBvcnQgaGFzaGluZwoK SGVyZSB3ZSBhZGQgRXhwclN0YXRlIHN1cHBvcnQgZm9yIG9idGFpbmluZyBhIDMyLWJpdCBoYXNo IHZhbHVlIGZyb20gYQpsaXN0IG9mIGV4cHJlc3Npb25zLiAgVGhpcyBhbGxvd3MgYm90aCBmYXN0 ZXIgaGFzaGluZyBhbmQgYWxzbyBKSVQKY29tcGlsYXRpb24gb2YgdGhlc2UgZXhwcmVzc2lvbnMu ICBUaGlzIGlzIGVzcGVjaWFsbHkgdXNlZnVsIHdoZW4gaGFzaApqb2lucyBoYXZlIG11bHRpcGxl IGpvaW4ga2V5cyBhcyB0aGUgcHJldmlvdXMgY29kZSBjYWxsZWQgRXhlY0V2YWxFeHByIG9uCmVh Y2ggaGFzaCBqb2luIGtleSBpbmRpdmlkdWFsbHkgYW5kIHRoYXQgd2FzIGluZWZmaWNpZW50IGFz IHR1cGxlCmRlZm9ybWF0aW9uIHdvdWxkIGhhdmUgb25seSB0YWtlbiBpbnRvIGFjY291bnQgb25l IGtleSBhdCBhIHRpbWUsIHdoaWNoCmNvdWxkIGxlYWQgdG8gd2Fsa2luZyB0aGUgdHVwbGUgb25j ZSBmb3IgZWFjaCBqb2luIGtleS4gIFdpdGggdGhlIG5ldwpjb2RlLCB3ZSdsbCBkZXRlcm1pbmUg dGhlIG1heGltdW0gYXR0cmlidXRlIHJlcXVpcmVkIGFuZCBkZWZvcm0gdGhlIHR1cGxlCnRvIHRo YXQgcG9pbnQgb25seSBvbmNlLgoKU29tZSBwZXJmb3JtYW5jZSB0ZXN0cyBkb25lIHdpdGggdGhp cyBjaGFuZ2UgaGF2ZSBzaG93biB1cCB0byBhIDIwJQpwZXJmb3JtYW5jZSBpbmNyZWFzZSBvZiBh IHF1ZXJ5IGNvbnRhaW5pbmcgYSBIYXNoIEpvaW4gd2l0aG91dCBKSVQKY29tcGlsYXRpb24gYW5k IHVwIHRvIGEgMjYlIHBlcmZvcm1hbmNlIGluY3JlYXNlIHdoZW4gSklUIGlzIGVuYWJsZWQgYW5k Cm9wdGltaXphdGlvbiBhbmQgaW5saW5pbmcgd2VyZSBwZXJmb3JtZWQgYnkgdGhlIEpJVCBjb21w aWxlci4gIFRoZQpwZXJmb3JtYW5jZSBpbmNyZWFzZSB3aXRoIDEgam9pbiBjb2x1bW4gd2FzIGxl c3Mgd2l0aCBhIDE0JSBpbmNyZWFzZQp3aXRoIGFuZCB3aXRob3V0IEpJVC4gIFRoaXMgdGVzdCB3 YXMgZG9uZSB1c2luZyBhIGZhaXJseSBzbWFsbCBoYXNoCnRhYmxlIGFuZCBhIGxhcmdlIG51bWJl ciBvZiBoYXNoIHByb2Jlcy4gIFRoZSBpbmNyZWFzZSB3aWxsIGxpa2VseSBiZQpsZXNzIHdpdGgg bGFyZ2UgdGFibGVzLCBlc3BlY2lhbGx5IG9uZXMgbGFyZ2VyIHRoYW4gTDMgY2FjaGUgYXMgbWVt b3J5CnByZXNzdXJlIGlzIG1vcmUgbGlrZWx5IHRvIGJlIHRoZSBsaW1pdGluZyBmYWN0b3IgdGhl cmUuCgpUaGlzIGNvbW1pdCBvbmx5IGFkZHJlc3NlcyBIYXNoIEpvaW5zLCBidXQgbGF5cyBleHBy ZXNzaW9uIGV2YWx1YXRpb24KYW5kIEpJVCBjb21waWxhdGlvbiBpbmZyYXN0cnVjdHVyZSBmb3Ig b3RoZXIgaGFzaGluZyBuZWVkcyBzdWNoIGFzIEhhc2gKQWdncmVnYXRlLgoKQXV0aG9yOiBEYXZp ZCBSb3dsZXkKUmV2aWV3ZWQtYnk6IEFsZXhleSBEdm9pY2hlbmtvdiA8YWxleGV5QGh5cGVycGxh bmUubmV0PgpSZXZpZXdlZC1ieTogVGVscyA8bm9zcGFtLXBnLWFidXNlQGJsb29kZ2F0ZS5jb20+ CkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0FBcEhEdm9leEF4Z1FGTlFEX0dSa3Iy T19lSlVEMS13VUdtJTNEbTBMJTJCR2MlM0RUJTNEa0VhNGclNDBtYWlsLmdtYWlsLmNvbQoKQnJh bmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3Fs Lm9yZy9wZy9jb21taXRkaWZmL2FkZjk3YzE1NjIzODBlMDJhY2Q2MGRjODU5YzI4OWVkM2E4MzUy ZWUKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL2V4 ZWNFeHByLmMgICAgICAgfCAxNDEgKysrKysrKysrKysrKysrKysrKysrKysKc3JjL2JhY2tlbmQv ZXhlY3V0b3IvZXhlY0V4cHJJbnRlcnAuYyB8IDExMCArKysrKysrKysrKysrKysrKysKc3JjL2Jh Y2tlbmQvZXhlY3V0b3Ivbm9kZUhhc2guYyAgICAgICB8IDE5MCArKysrKysrLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL25vZGVIYXNoam9pbi5jICAgfCAxNDMg KysrKysrKysrKysrKysrKysrKystLS0tCnNyYy9iYWNrZW5kL2ppdC9sbHZtL2xsdm1qaXRfZXhw ci5jICAgfCAyMDQgKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKwpzcmMvaW5jbHVk ZS9leGVjdXRvci9leGVjRXhwci5oICAgICAgIHwgIDI0ICsrKysKc3JjL2luY2x1ZGUvZXhlY3V0 b3IvZXhlY3V0b3IuaCAgICAgICB8ICAgNyArKwpzcmMvaW5jbHVkZS9leGVjdXRvci9oYXNoam9p bi5oICAgICAgIHwgIDEyIC0tCnNyYy9pbmNsdWRlL2V4ZWN1dG9yL25vZGVIYXNoLmggICAgICAg fCAgIDkgKy0Kc3JjL2luY2x1ZGUvbm9kZXMvZXhlY25vZGVzLmggICAgICAgICB8ICAxMiArLQox MCBmaWxlcyBjaGFuZ2VkLCA2NTAgaW5zZXJ0aW9ucygrKSwgMjAyIGRlbGV0aW9ucygtKQoK --===============6428464342674129031==--