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 1uShqp-00BzZD-P2 for pgsql-committers@arkaria.postgresql.org; Fri, 20 Jun 2025 19:56:39 +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 1uShqn-00435s-Rv for pgsql-committers@arkaria.postgresql.org; Fri, 20 Jun 2025 19:56:38 +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 1uShqn-00435k-Ki for pgsql-committers@lists.postgresql.org; Fri, 20 Jun 2025 19:56:38 +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 1uShql-003C9a-2m for pgsql-committers@lists.postgresql.org; Fri, 20 Jun 2025 19:56:37 +0000 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 1uShqj-008qSB-Rj for pgsql-committers@lists.postgresql.org; Fri, 20 Jun 2025 19:56:33 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uShqj-002arr-0a for pgsql-committers@lists.postgresql.org; Fri, 20 Jun 2025 19:56:33 +0000 Content-Type: multipart/mixed; boundary="===============7142966212687771473==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Remove planner's have_dangerous_phv() join-order restriction. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 20 Jun 2025 19:56:33 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7142966212687771473== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UmVtb3ZlIHBsYW5uZXIncyBoYXZlX2Rhbmdlcm91c19waHYoKSBqb2luLW9yZGVyIHJlc3RyaWN0 aW9uLgoKQ29tbWl0IDg1ZTVlMjIyYiwgd2hpY2ggYWRkZWQgKGEgZm9yZXJ1bm5lciBvZikgdGhp cyBsb2dpYywKYXJndWVkIHRoYXQKCiAgICBBZGRpbmcgdGhlIG5lY2Vzc2FyeSBjb21wbGV4aXR5 IHRvIG1ha2UgdGhpcyB3b3JrIGRvZXNuJ3Qgc2VlbSBsaWtlCiAgICBpdCB3b3VsZCBiZSByZXBh aWQgaW4gc2lnbmlmaWNhbnRseSBiZXR0ZXIgcGxhbnMsIGJlY2F1c2UgaW4gY2FzZXMKICAgIHdo ZXJlIHN1Y2ggYSBQSFYgZXhpc3RzLCB0aGVyZSBpcyBwcm9iYWJseSBhIGNvcnJlc3BvbmRpbmcg am9pbiBvcmRlcgogICAgY29uc3RyYWludCB0aGF0IHdvdWxkIGFsbG93IGEgZ29vZCBwbGFuIHRv IGJlIGZvdW5kIHdpdGhvdXQgdXNpbmcgdGhlCiAgICBzdGFyLXNjaGVtYSBleGNlcHRpb24uCgpU aGUgZmxhdyBpbiB0aGlzIGNsYWltIGlzIHRoYXQgdGhlcmUgbWF5IGJlIG90aGVyIGpvaW4tb3Jk ZXIKcmVzdHJpY3Rpb25zIHRoYXQgcHJldmVudCB1cyBmcm9tIGZpbmRpbmcgYSBqb2luIG9yZGVy IHRoYXQgZG9lc24ndAppbnZvbHZlIGEgImRhbmdlcm91cyIgUEhWLiAgSW4gcGFydGljdWxhciB3 ZSBub3cgcmVjb2duaXplIHRoYXQKc21hbGwgam9pbl9jb2xsYXBzZV9saW1pdCBvciBmcm9tX2Nv bGxhcHNlX2xpbWl0IGNvdWxkIHByZXZlbnQgaXQuClRoZXJlZm9yZSwgbGV0J3MgYml0ZSB0aGUg YnVsbGV0IGFuZCBtYWtlIHRoZSBjYXNlIHdvcmsuCgpXZSBkb24ndCBoYXZlIHRvIGV4dGVuZCB0 aGUgZXhlY3V0b3IncyBzdXBwb3J0IGZvciBuZXN0bG9vcCBwYXJhbWV0ZXJzCmFzIEkgdGhvdWdo dCBhdCB0aGUgdGltZSwgYmVjYXVzZSB3ZSBjYW4gaW5zdGVhZCBwdXNoIHRoZSBldmFsdWF0aW9u Cm9mIHRoZSBwbGFjZWhvbGRlcidzIGV4cHJlc3Npb24gaW50byB0aGUgbGVmdC1oYW5kIGlucHV0 IG9mIHRoZQpOZXN0TG9vcCBub2RlLiAgU28gdGhlcmUncyBub3QgcmVhbGx5IGEgbG90IG9mIGRv d25zaWRlIHRvIHRoaXMKc29sdXRpb24sIGFuZCBnaXZpbmcgdGhlIHBsYW5uZXIgbW9yZSBqb2lu LW9yZGVyIGZsZXhpYmlsaXR5IHNob3VsZApoYXZlIHZhbHVlIGJleW9uZCBqdXN0IGF2b2lkaW5n IGZhaWx1cmUuCgpIYXZpbmcgc2FpZCB0aGF0LCB0aGVyZSBzdXJlbHkgaXMgYSBub256ZXJvIHJp c2sgb2YgaW50cm9kdWNpbmcKbmV3IGJ1Z3MuICBTaW5jZSB0aGlzIGZhaWx1cmUgbW9kZSBlc2Nh cGVkIGRldGVjdGlvbiBmb3IgdGVuIHllYXJzLApzdWNoIGNhc2VzIGRvbid0IHNlZW0gY29tbW9u IGVub3VnaCB0byBqdXN0aWZ5IGEgbG90IG9mIHJpc2suClRoZXJlZm9yZSwgbGV0J3MgcHV0IHRo aXMgZml4IGludG8gbWFzdGVyIGJ1dCBsZWF2ZSB0aGUgYmFjayBicmFuY2hlcwphbG9uZSAoZm9y IG5vdyBhbnl3YXkpLgoKQnVnOiAjMTg5NTMKUmVwb3J0ZWQtYnk6IEFsZXhhbmRlciBMYWtoaW4g PGV4Y2x1c2lvbkBnbWFpbC5jb20+CkRpYWdub3NlZC1ieTogUmljaGFyZCBHdW8gPGd1b2Zlbmds aW51eEBnbWFpbC5jb20+CkF1dGhvcjogVG9tIExhbmUgPHRnbEBzc3MucGdoLnBhLnVzPgpEaXNj dXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzE4OTUzLTFjOTg4M2E5ZDRhZmViMzBAcG9zdGdy ZXNxbC5vcmcKCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9n aXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9hMTZlZjMxM2YyYzIxMjI1ZTg5ZGRiOTE2 OGYzMDYwMWYyMWM3ZDA3CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2Vu ZC9vcHRpbWl6ZXIvcGF0aC9qb2lucGF0aC5jICAgIHwgIDkgKystLQpzcmMvYmFja2VuZC9vcHRp bWl6ZXIvcGF0aC9qb2lucmVscy5jICAgIHwgNjAgLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0Kc3Jj L2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vY3JlYXRlcGxhbi5jICB8IDQ2ICsrKysrKysrKysrKysr Ky0tCnNyYy9iYWNrZW5kL29wdGltaXplci91dGlsL3BhcmFtYXNzaWduLmMgfCAzOSArKysrKysr KysrLS0tLS0Kc3JjL2luY2x1ZGUvb3B0aW1pemVyL3BhcmFtYXNzaWduLmggICAgICB8ICAyICst CnNyYy9pbmNsdWRlL29wdGltaXplci9wYXRocy5oICAgICAgICAgICAgfCAgMiAtCnNyYy90ZXN0 L3JlZ3Jlc3MvZXhwZWN0ZWQvam9pbi5vdXQgICAgICAgfCA4NCArKysrKysrKysrKysrKysrKysr KysrKysrKysrKysrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9qb2luLnNxbCAgICAgICAgICAgIHwg MjkgKysrKysrKysrKysKOCBmaWxlcyBjaGFuZ2VkLCAxODggaW5zZXJ0aW9ucygrKSwgODMgZGVs ZXRpb25zKC0pCgo= --===============7142966212687771473==--