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 1suHCL-005ZXB-VW for pgsql-committers@arkaria.postgresql.org; Fri, 27 Sep 2024 20:04:18 +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 1suHCJ-00EPtK-Od for pgsql-committers@arkaria.postgresql.org; Fri, 27 Sep 2024 20:04:15 +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 1suHCJ-00EPtB-GZ for pgsql-committers@lists.postgresql.org; Fri, 27 Sep 2024 20:04:15 +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 1suHCG-001MxW-Jd for pgsql-committers@lists.postgresql.org; Fri, 27 Sep 2024 20:04:14 +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 1suHCF-004GT4-Ax for pgsql-committers@lists.postgresql.org; Fri, 27 Sep 2024 20:04:11 +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 1suHCE-001CFp-Eq for pgsql-committers@lists.postgresql.org; Fri, 27 Sep 2024 20:04:11 +0000 Content-Type: multipart/mixed; boundary="===============6937044883124879493==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Recalculate where-needed data accurately after a join removal. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 27 Sep 2024 20:04:11 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6937044883124879493== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UmVjYWxjdWxhdGUgd2hlcmUtbmVlZGVkIGRhdGEgYWNjdXJhdGVseSBhZnRlciBhIGpvaW4gcmVt b3ZhbC4KClVwIHRvIG5vdywgcmVtb3ZlX3JlbF9mcm9tX3F1ZXJ5KCkgaGFzIGRvbmUgYSBwcmV0 dHkgc2hvZGR5IGpvYgpvZiB1cGRhdGluZyBvdXIgd2hlcmUtbmVlZGVkIGJpdG1hcHMgKHBlci1W YXIgYXR0cl9uZWVkZWQgYW5kCnBlci1QbGFjZUhvbGRlclZhciBwaF9uZWVkZWQgcmVsaWQgc2V0 cykuICBJdCByZW1vdmVkIGRpcmVjdCBtZW50aW9ucwpvZiB0aGUgdG8tYmUtcmVtb3ZlZCBiYXNl cmVsIGFuZCBvdXRlciBqb2luLCB3aGljaCBpcyB0aGUgbWluaW11bQphbW91bnQgb2YgZWZmb3J0 IG5lZWRlZCB0byBrZWVwIHRoZSBkYXRhIHN0cnVjdHVyZXMgc2VsZi1jb25zaXN0ZW50LgpCdXQg aXQgZGlkbid0IGFjY291bnQgZm9yIHRoZSBmYWN0IHRoYXQgdGhlIHJlbW92ZWQgam9pbiBPTiBj bGF1c2UKcHJvYmFibHkgbWVudGlvbmVkIFZhcnMgb2Ygb3RoZXIgcmVsYXRpb25zLCBhbmQgdGhv c2UgVmFycyBtaWdodCBub3cKbm90IGJlIG5lZWRlZCBhcyBoaWdoIHVwIGluIHRoZSBqb2luIHRy ZWUgYXMgYmVmb3JlLiAgSXQncyBlYXN5IHRvCnNob3cgY2FzZXMgd2hlcmUgdGhpcyByZXN1bHRz IGluIGZhaWxpbmcgdG8gcmVtb3ZlIGEgbG93ZXIgb3V0ZXIgam9pbgp0aGF0IGNvdWxkIGFsc28g aGF2ZSBiZWVuIHJlbW92ZWQuCgpUbyBmaXgsIHJlY2FsY3VsYXRlIHRoZSB3aGVyZS1uZWVkZWQg Yml0bWFwcyBmcm9tIHNjcmF0Y2ggYWZ0ZXIKZWFjaCBzdWNjZXNzZnVsIGpvaW4gcmVtb3ZhbC4g IFRoaXMgc291bmRzIGV4cGVuc2l2ZSwgYnV0IGl0IHNlZW1zCnRvIGFkZCBvbmx5IG5lZ2xpZ2li bGUgcGxhbm5lciBydW50aW1lLiAgKFdlIGNoZWF0IGEgbGl0dGxlIGJpdApieSBwcmVzZXJ2aW5n ICJyZWxhdGlvbiAwIiBlbnRyaWVzIGluIHRoZSBiaXRtYXBzLCBhbGxvd2luZyB1cyB0bwpza2lw IHJlLXNjYW5uaW5nIHRoZSB0YXJnZXRsaXN0IGFuZCBIQVZJTkcgcXVhbC4pCgpUaGUgc3VibWl0 dGVkIHRlc3QgY2FzZSBkcmV3IGF0dGVudGlvbiBiZWNhdXNlIHdlIGhhZCBzdWNjZXNzZnVsbHkK b3B0aW1pemVkIGF3YXkgdGhlIGxvd2VyIGpvaW4gcHJpb3IgdG8gdjE2LiAgSSBzdXNwZWN0IHRo YXQgdGhhdCdzCnNvbWV3aGF0IGFjY2lkZW50YWwgYW5kIHRoZXJlIGFyZSByZWxhdGVkIGNhc2Vz IHRoYXQgd2VyZSBuZXZlcgpvcHRpbWl6ZWQgYmVmb3JlIGFuZCBub3cgY2FuIGJlLiAgSSd2ZSBu b3QgdHJpZWQgdG8gY29tZSB1cCB3aXRoCm9uZSwgdGhvdWdoLgoKUGVyaGFwcyB3ZSBzaG91bGQg YmFjay1wYXRjaCB0aGlzIGludG8gdjE2IGFuZCB2MTcgdG8gcmVwYWlyIHRoZQpwZXJmb3JtYW5j ZSByZWdyZXNzaW9uLiAgSG93ZXZlciwgc2luY2UgaXQgdG9vayBhIHllYXIgZm9yIGFueW9uZQp0 byBub3RpY2UgdGhlIHByb2JsZW0sIGl0IGNhbid0IGJlIGFmZmVjdGluZyB0b28gbWFueSBwZW9w bGUuICBMZXQncwpsZXQgdGhlIHBhdGNoIGJha2UgYXdoaWxlIGluIEhFQUQsIGFuZCBzZWUgaWYg d2UgZ2V0IG1vcmUgY29tcGxhaW50cy4KClBlciBidWcgIzE4NjI3IGZyb20gTWlrYcOrbCBHb3Vy bGFvdWVuLiAgTm8gYmFjay1wYXRjaCBmb3Igbm93LgoKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0 Z3IuZXMvbS8xODYyNy00NGY5NTBlYjZhODQxNmMyQHBvc3RncmVzcWwub3JnCgpCcmFuY2gKLS0t LS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3Bn L2NvbW1pdGRpZmYvYTMxNzlhYjY5MmJlNDMxNGQ1ZWU1Y2Q1NjU5ODk3NmM0ODdkNWVmMgoKTW9k aWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BhdGgvZXF1 aXZjbGFzcy5jICAgfCAgNDEgKysrKysrLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9hbmFs eXplam9pbnMuYyB8ICA4NSArKysrKysrKy0tLS0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxh bi9pbml0c3BsYW4uYyAgICB8IDE3OSArKysrKysrKysrKysrKysrKysrKysrKysrKysrKy0Kc3Jj L2JhY2tlbmQvb3B0aW1pemVyL3V0aWwvcGxhY2Vob2xkZXIuYyAgfCAgMjcgKysrKysKc3JjL2lu Y2x1ZGUvb3B0aW1pemVyL3BhdGhzLmggICAgICAgICAgICAgfCAgIDEgKwpzcmMvaW5jbHVkZS9v cHRpbWl6ZXIvcGxhY2Vob2xkZXIuaCAgICAgICB8ICAgMSArCnNyYy9pbmNsdWRlL29wdGltaXpl ci9wbGFubWFpbi5oICAgICAgICAgIHwgICA0ICsKc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9q b2luLm91dCAgICAgICAgfCAgMTIgKy0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvam9pbi5zcWwgICAg ICAgICAgICAgfCAgIDcgKy0KOSBmaWxlcyBjaGFuZ2VkLCAzMjAgaW5zZXJ0aW9ucygrKSwgMzcg ZGVsZXRpb25zKC0pCgo= --===============6937044883124879493==--