Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pkAE6-0005iG-HW for pgsql-committers@arkaria.postgresql.org; Wed, 05 Apr 2023 20:59:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pkAE5-0001Xw-A6 for pgsql-committers@arkaria.postgresql.org; Wed, 05 Apr 2023 20:59:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pkAE5-0001Xm-1z for pgsql-committers@lists.postgresql.org; Wed, 05 Apr 2023 20:59:29 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pkAE2-0000TF-Md for pgsql-committers@lists.postgresql.org; Wed, 05 Apr 2023 20:59:28 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pkAE2-0003d7-2K for pgsql-committers@lists.postgresql.org; Wed, 05 Apr 2023 20:59:26 +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 1pkAE0-001Y6Q-9z for pgsql-committers@lists.postgresql.org; Wed, 05 Apr 2023 20:59:25 +0000 Content-Type: multipart/mixed; boundary="===============1624746683881258723==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Support "Right Anti Join" plan shapes. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 05 Apr 2023 20:59:25 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1624746683881258723== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U3VwcG9ydCAiUmlnaHQgQW50aSBKb2luIiBwbGFuIHNoYXBlcy4KCk1lcmdlIGFuZCBoYXNoIGpv aW5zIGNhbiBzdXBwb3J0IGFudGlqb2luIHdpdGggdGhlIG5vbi1udWxsYWJsZSBpbnB1dApvbiB0 aGUgcmlnaHQsIHVzaW5nIHZlcnkgc2ltcGxlIGNvbWJpbmF0aW9ucyBvZiB0aGVpciBleGlzdGlu ZyBsb2dpYwpmb3IgcmlnaHQgam9pbiBhbmQgYW50aSBqb2luLiAgVGhpcyBnaXZlcyB0aGUgcGxh bm5lciBtb3JlIGZyZWVkb20KYWJvdXQgaG93IHRvIG9yZGVyIHRoZSBqb2luLiAgSXQncyBwYXJ0 aWN1bGFybHkgdXNlZnVsIGZvciBoYXNoIGpvaW4sCnNpbmNlIHdlIG1heSBub3cgaGF2ZSB0aGUg b3B0aW9uIHRvIGhhc2ggdGhlIHNtYWxsZXIgdGFibGUgaW5zdGVhZApvZiB0aGUgbGFyZ2VyLgoK UmljaGFyZCBHdW8sIHJldmlld2VkIGJ5IFJvbmFuIER1bmtsYXUgYW5kIG15c2VsZgoKRGlzY3Vz c2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQU1iV3M0OHhoOWhNelh6U3kzVmFQekdBeitma3hY WFRVYkNMb2hYMV9MOFRIRlJtMlFAbWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVy CgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlm Zi8xNmRjMjcwM2M1NDEzNTM0ZDQ5ODllMDgyNTNlOGY0ZmNiMGUyYWFiCgpNb2RpZmllZCBGaWxl cwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9jb21tYW5kcy9leHBsYWluLmMgICAgICAgICAg ICAgICB8ICAgMyArCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL25vZGVIYXNoam9pbi5jICAgICAgICAg IHwgIDM1ICsrLS0Kc3JjL2JhY2tlbmQvZXhlY3V0b3Ivbm9kZU1lcmdlam9pbi5jICAgICAgICAg fCAgMzMgKystLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9jb3N0c2l6ZS5jICAgICAgICB8 ICAgMyArLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9qb2lucGF0aC5jICAgICAgICB8ICA0 OSArKystLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9qb2lucmVscy5jICAgICAgICB8ICAg MyArCnNyYy9iYWNrZW5kL29wdGltaXplci9wYXRoL3BhdGhrZXlzLmMgICAgICAgIHwgIDEwICst CnNyYy9iYWNrZW5kL29wdGltaXplci9wcmVwL3ByZXBqb2ludHJlZS5jICAgIHwgIDE0ICstCnNy Yy9pbmNsdWRlL25vZGVzL2V4ZWNub2Rlcy5oICAgICAgICAgICAgICAgIHwgICAzICstCnNyYy9p bmNsdWRlL25vZGVzL25vZGVzLmggICAgICAgICAgICAgICAgICAgIHwgICA0ICstCnNyYy9pbmNs dWRlL25vZGVzL3BhdGhub2Rlcy5oICAgICAgICAgICAgICAgIHwgICA1ICstCnNyYy90ZXN0L3Jl Z3Jlc3MvZXhwZWN0ZWQvcGFydGl0aW9uX2pvaW4ub3V0IHwgMjc2ICsrKysrKysrKysrKysrLS0t LS0tLS0tLS0tLQoxMiBmaWxlcyBjaGFuZ2VkLCAyNDQgaW5zZXJ0aW9ucygrKSwgMTk0IGRlbGV0 aW9ucygtKQoK --===============1624746683881258723==--