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 1uX9Dy-006MkS-4w for pgsql-committers@arkaria.postgresql.org; Thu, 03 Jul 2025 01:58:54 +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 1uX9Du-007O8y-IO for pgsql-committers@arkaria.postgresql.org; Thu, 03 Jul 2025 01:58:51 +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 1uX9Du-007O8f-5z for pgsql-committers@lists.postgresql.org; Thu, 03 Jul 2025 01:58:50 +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.96) (envelope-from ) id 1uX9Ds-005Prk-0b for pgsql-committers@lists.postgresql.org; Thu, 03 Jul 2025 01:58: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=Y9ehqs4rAvOWcsXQpH3+ZQG/cKG/WdJrFNHAJ+m5mwA=; b=TCP62Li4Al5Arbl/hVvyg/jt2n 4MseU3urCI9AxyGbBgdbY86FS5uEhlp37mkzEjQW5LIWHGomVWaQm3WcamHWSB0wNeZzNfGEauFBO +k9NoD5bAAqPzbw0Qm6vQNa01KRfwFvOOERuX3sm/SG2A/H76T6pncJVftujXSCMHFY2bjrmrtD5n j/OnMIz/L/EzGqg9SCl3Utdw5a1gLfIFzZxMOrD6OqKWr8DFfcAqoBi7moohqotTt8S/Bz3mO8sRP aPiyVsHWYUYHMi1wRj7D9p25bG9cazi5xgO40rk1Zl0dLh/HkaHJEtl7gKPP3nU0BeOWGhP/OFrFy nU/4ymjg==; 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 1uX9Dq-00EdKG-JM for pgsql-committers@lists.postgresql.org; Thu, 03 Jul 2025 01:58:46 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uX9Dp-004RNE-2f for pgsql-committers@lists.postgresql.org; Thu, 03 Jul 2025 01:58:45 +0000 Content-Type: multipart/mixed; boundary="===============4929884198589059873==" MIME-Version: 1.0 From: Richard Guo To: pgsql-committers@lists.postgresql.org Subject: pgsql: Enable use of Memoize for ANTI joins X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 03 Jul 2025 01:58:45 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4929884198589059873== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RW5hYmxlIHVzZSBvZiBNZW1vaXplIGZvciBBTlRJIGpvaW5zCgpDdXJyZW50bHksIHdlIGRvIG5v dCBzdXBwb3J0IE1lbW9pemUgZm9yIFNFTUkgYW5kIEFOVEkgam9pbnMgYmVjYXVzZQpuZXN0ZWQg bG9vcCBTRU1JL0FOVEkgam9pbnMgZG8gbm90IHNjYW4gdGhlIGlubmVyIHJlbGF0aW9uIHRvCmNv bXBsZXRpb24sIHdoaWNoIHByZXZlbnRzIE1lbW9pemUgZnJvbSBtYXJraW5nIHRoZSBjYWNoZSBl bnRyeSBhcwpjb21wbGV0ZS4gIE9uZSBtaWdodCBhcmd1ZSB0aGF0IHdlIGNvdWxkIG1hcmsgdGhl IGNhY2hlIGVudHJ5IGFzCmNvbXBsZXRlIGFmdGVyIGZldGNoaW5nIHRoZSBmaXJzdCBpbm5lciB0 dXBsZSwgYnV0IHRoYXQgd291bGQgbm90IGJlCnNhZmU6IGlmIHRoZSBmaXJzdCBpbm5lciB0dXBs ZSBhbmQgdGhlIGN1cnJlbnQgb3V0ZXIgdHVwbGUgZG8gbm90CnNhdGlzZnkgdGhlIGpvaW4gY2xh dXNlcywgYSBzZWNvbmQgaW5uZXIgdHVwbGUgbWF0Y2hpbmcgdGhlIHBhcmFtZXRlcnMKd291bGQg ZmluZCB0aGUgY2FjaGUgZW50cnkgYWxyZWFkeSBtYXJrZWQgYXMgY29tcGxldGUuCgpIb3dldmVy LCBpZiB0aGUgaW5uZXIgc2lkZSBpcyBwcm92YWJseSB1bmlxdWUsIHRoaXMgaXNzdWUgZG9lc24n dAphcmlzZSwgc2luY2UgdGhlcmUgd291bGQgYmUgbm8gc2Vjb25kIG1hdGNoaW5nIHR1cGxlLiAg VGhhdCBzYWlkLCB0aGlzCmRvZXNuJ3QgaGVscCBpbiB0aGUgY2FzZSBvZiBTRU1JIGpvaW5zLCBi ZWNhdXNlIGEgU0VNSSBqb2luIHdpdGggYQpwcm92YWJseSB1bmlxdWUgaW5uZXIgc2lkZSB3b3Vs ZCBhbHJlYWR5IGhhdmUgYmVlbiByZWR1Y2VkIHRvIGFuIGlubmVyCmpvaW4gYnkgcmVkdWNlX3Vu aXF1ZV9zZW1pam9pbnMuCgpUaGVyZWZvcmUsIGluIHRoaXMgcGF0Y2gsIHdlIGNoZWNrIHdoZXRo ZXIgdGhlIGlubmVyIHJlbGF0aW9uIGlzCnByb3ZhYmx5IHVuaXF1ZSBmb3IgQU5USSBqb2lucyBh bmQgZW5hYmxlIHRoZSB1c2Ugb2YgTWVtb2l6ZSBpbiBzdWNoCmNhc2VzLgoKQXV0aG9yOiBSaWNo YXJkIEd1byA8Z3VvZmVuZ2xpbnV4QGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IHdlbmh1aSBxaXUg PHFpdXdlbmh1aWZ4QGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IEFuZHJlaSBMZXBpa2hvdiA8bGVw aWhvdkBnbWFpbC5jb20+CkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0FNYldzNDhG ZExpTU5ybUpMLWc2bUR2b1FWdDB5TnlKQXFNa3Y0ZTJQay01R0tDWkxBQG1haWwuZ21haWwuY29t CgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3Rn cmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvMGRhMjllNGNiMTYxZjc4YTVlZjUzNGIzZmI0NDY3NzU2 YTQyMmUyNQoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1p emVyL3BhdGgvam9pbnBhdGguYyB8IDQ3ICsrKysrKysrKysrKysrLS0tLS0tLS0tLS0tLQpzcmMv dGVzdC9yZWdyZXNzL2V4cGVjdGVkL21lbW9pemUub3V0IHwgNjAgKysrKysrKysrKysrKysrKysr KysrKysrKysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvbWVtb2l6ZS5zcWwgICAgICB8 IDI3ICsrKysrKysrKysrKysrKysKMyBmaWxlcyBjaGFuZ2VkLCAxMTIgaW5zZXJ0aW9ucygrKSwg MjIgZGVsZXRpb25zKC0pCgo= --===============4929884198589059873==--