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 1tL8ma-00Cy1S-57 for pgsql-committers@arkaria.postgresql.org; Tue, 10 Dec 2024 22:32:44 +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 1tL8mX-009XY2-8I for pgsql-committers@arkaria.postgresql.org; Tue, 10 Dec 2024 22:32:42 +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 1tL8mW-009XXu-EM for pgsql-committers@lists.postgresql.org; Tue, 10 Dec 2024 22:32:42 +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 1tL8mU-0029RK-NL for pgsql-committers@lists.postgresql.org; Tue, 10 Dec 2024 22:32:40 +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=skfQKctJGuIzMdh4NJ9NgCIsRQadEe0DmXvgcQWV02E=; b=TFfNSdJOO3KwnHiOkeMSmoJU9L YZ8Pgm3jv+9e8uRLU1bi0lCRk/YkZfH+ZLxDHroRYUL2fFe+JETuo3exWfQmr+GIyQgpYMjBaOCGl agBR6Rr667u8rA70eXLlfdxuj0t3Eoe/YKTh6fbtvz7+PWPtaSZUQHAiArzDaH0n+o3BLvCYzSBVt T5C1X1hApqydD3dSSZuG+R34zxrV5RFyDtf6mYx0rEZexEVEATO8LUTAqIAHICclZCqo/U5vONCSy oMvaqg4wsG49LznKgl0dfObblxKb/SYOe7yunLQocH/RIYw3fzY9xwRtxv98Y4N5W2MZeErmmWFtR aQiK+PSQ==; 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 1tL8mT-006hzn-Ps for pgsql-committers@lists.postgresql.org; Tue, 10 Dec 2024 22:32:37 +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 1tL8mS-0026L0-Cj for pgsql-committers@lists.postgresql.org; Tue, 10 Dec 2024 22:32:37 +0000 Content-Type: multipart/mixed; boundary="===============4632077814573583459==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Speedup Hash Joins with dedicated functions for ExprState hashin X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 10 Dec 2024 22:32:37 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4632077814573583459== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U3BlZWR1cCBIYXNoIEpvaW5zIHdpdGggZGVkaWNhdGVkIGZ1bmN0aW9ucyBmb3IgRXhwclN0YXRl IGhhc2hpbmcKCkhhc2hpbmcgb2YgYSBzaW5nbGUgVmFyIGlzIGEgdmVyeSBjb21tb24gb3BlcmF0 aW9uIGZvciBFeHByU3RhdGUgdG8KcGVyZm9ybS4gIEhlcmUgd2UgYWRkIGRlZGljYXRlZCBFeGVj SnVzdCogZnVuY3Rpb25zIHdoaWNoIGhlbHBzIHNwZWVkIHVwCkhhc2ggSm9pbnMgYnkgcmVtb3Zp bmcgdGhlIGludGVycHJldGF0aW9uIG92ZXJoZWFkIGluIEV4ZWNJbnRlcnBFeHByKCkuCgpUaGlz IGNoYW5nZSBjdXJyZW50bHkgb25seSBhZmZlY3RzIEhhc2ggSm9pbnMgb24gYSBzaW5nbGUgY29s dW1uLiAgSGFzaApKb2lucyB3aXRoIG11bHRpcGxlIGpvaW4ga2V5cyBvciBhbiBleHByZXNzaW9u IHN0aWxsIHJ1biB0aHJvdWdoCkV4ZWNJbnRlcnBFeHByKCkuCgpTb21lIHRlc3RpbmcgaGFzIHNo b3duIHVwIHRvIDEwJSBxdWVyeSBwZXJmb3JtYW5jZSBpbmNyZWFzZXMgb24gcmVjZW50IEFNRApo YXJkd2FyZSBhbmQgbmVhcmx5IDclIGluY3JlYXNlIG9uIGFuIEFwcGxlIE0yIGZvciBhIHF1ZXJ5 IHBlcmZvcm1pbmcgYQpoYXNoIGpvaW4gd2l0aCBhIGxhcmdlIG51bWJlciBvZiBsb29rdXBzIG9u IGEgc21hbGwgaGFzaCB0YWJsZS4KClRoaXMgY2hhbmdlIHdhcyBleHRyYWN0ZWQgZnJvbSBhIGxh cmdlciBwYXRjaCB3aGljaCBhZGp1c3RzIEdST1VQIEJZIC8KaGFzaGVkIHN1YnBsYW5zIC8gaGFz aGVkIHNldCBvcGVyYXRpb25zIHRvIHVzZSBFeHByU3RhdGUgaGFzaGluZy4KCkRpc2N1c3Npb246 IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0FBcEhEdnI4WmMwWmd6Vm9DWkxkSEdPRk5oaUplUTZ2clVj UzlWN04yM3pNV1FiLWVBQG1haWwuZ21haWwuY29tCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0 YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvNTA0 MTZjYzQ4NDNhODVmY2I1MzUwN2UyMTU3N2NjZTE2Yzc1YzY1ZgoKTW9kaWZpZWQgRmlsZXMKLS0t LS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvZXhlY3V0b3IvZXhlY0V4cHJJbnRlcnAuYyB8IDIwNiAr KysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKystCjEgZmlsZSBjaGFuZ2VkLCAyMDUgaW5z ZXJ0aW9ucygrKSwgMSBkZWxldGlvbigtKQoK --===============4632077814573583459==--