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 1thuOO-008NHy-2m for pgsql-committers@arkaria.postgresql.org; Tue, 11 Feb 2025 17:49:52 +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 1thuOM-00DZTE-MN for pgsql-committers@arkaria.postgresql.org; Tue, 11 Feb 2025 17:49:50 +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 1thuOM-00DZSy-9p for pgsql-committers@lists.postgresql.org; Tue, 11 Feb 2025 17:49:50 +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.96) (envelope-from ) id 1thuOJ-000GES-2m for pgsql-committers@lists.postgresql.org; Tue, 11 Feb 2025 17:49:49 +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 1thuOJ-001wga-03 for pgsql-committers@lists.postgresql.org; Tue, 11 Feb 2025 17:49:47 +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 1thuOI-006aao-2h for pgsql-committers@lists.postgresql.org; Tue, 11 Feb 2025 17:49:46 +0000 Content-Type: multipart/mixed; boundary="===============2084610451424400280==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Implement new optimization rule for updates of expanded variable X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 11 Feb 2025 17:49:46 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2084610451424400280== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW1wbGVtZW50IG5ldyBvcHRpbWl6YXRpb24gcnVsZSBmb3IgdXBkYXRlcyBvZiBleHBhbmRlZCB2 YXJpYWJsZXMuCgpJZiBhIHJlYWQvd3JpdGUgZXhwYW5kZWQgdmFyaWFibGUgaXMgZGVjbGFyZWQg bG9jYWxseSB0byB0aGUKYXNzaWdubWVudCBzdGF0ZW1lbnQgdGhhdCBpcyB1cGRhdGluZyBpdCwg YW5kIGl0IGlzIHJlZmVyZW5jZWQKZXhhY3RseSBvbmNlIGluIHRoZSBhc3NpZ25tZW50IFJIUywg dGhlbiB3ZSBjYW4gb3B0aW1pemUgdGhlCm9wZXJhdGlvbiBhcyBhIGRpcmVjdCB1cGRhdGUgb2Yg dGhlIGV4cGFuZGVkIHZhbHVlLCB3aGV0aGVyCm9yIG5vdCB0aGUgZnVuY3Rpb24ocykgb3BlcmF0 aW5nIG9uIGl0IGNhbiBiZSB0cnVzdGVkIG5vdCB0bwptb2RpZnkgdGhlIHZhbHVlIGJlZm9yZSB0 aHJvd2luZyBhbiBlcnJvci4gIFRoaXMgd29ya3MgYmVjYXVzZQppZiBhbiBlcnJvciBkb2VzIGdl dCB0aHJvd24sIHdlIG5vIGxvbmdlciBjYXJlIHdoYXQgdmFsdWUgdGhlCnZhcmlhYmxlIGhhcy4K CkluIGNhc2VzIHdoZXJlIHRoYXQgZG9lc24ndCB3b3JrLCBmYWxsIGJhY2sgdG8gdGhlIHByZXZp b3VzCnJ1bGUgdGhhdCBjaGVja3MgZm9yIHNhZmV0eSBvZiB0aGUgdG9wLWxldmVsIGZ1bmN0aW9u LgoKSW4gYW55IGNhc2UsIHBvc3Rwb25lIGRldGVybWluYXRpb24gb2Ygd2hldGhlciB0aGVzZSBv cHRpbWl6YXRpb25zCmFyZSBmZWFzaWJsZSB1bnRpbCB3ZSBhcmUgZXhlY3V0aW5nIGEgUGFyYW0g cmVmZXJlbmNpbmcgdGhlIHRhcmdldAp2YXJpYWJsZSBhbmQgdGhhdCB2YXJpYWJsZSBob2xkcyBh IFIvVyBleHBhbmRlZCBvYmplY3QuICBXaGlsZSB0aGUKcHJldmlvdXMgaW5jYXJuYXRpb24gb2Yg ZXhlY19jaGVja19yd19wYXJhbWV0ZXIgd2FzIHByZXR0eSBjaGVhcCwKdGhpcyBpcyBhIGJpdCBs ZXNzIHNvLCBhbmQgb3VyIHBsYW4gdG8gaW52b2tlIHN1cHBvcnQgZnVuY3Rpb25zCndpbGwgbWFr ZSBpdCBldmVuIGxlc3Mgc28uICBTbyBhdm9pZGluZyB0aGUgY2hlY2sgZm9yIHZhcmlhYmxlcwp3 aGVyZSBpdCBjb3VsZG4ndCBiZSB1c2VmdWwgc2hvdWxkIGJlIGEgd2luLgoKQXV0aG9yOiBUb20g TGFuZSA8dGdsQHNzcy5wZ2gucGEudXM+ClJldmlld2VkLWJ5OiBBbmRyZXkgQm9yb2RpbiA8eDRt bW1AeWFuZGV4LXRlYW0ucnU+ClJldmlld2VkLWJ5OiBQYXZlbCBCb3Jpc292IDxwYXNoa2luLmVs ZmVAZ21haWwuY29tPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NBQ3h1PXZKYUtG TnNZeG9vU25XMXdFZ3NBTzV1X3YxWFlCYWNmVkoxNHdnSlZfUFllZ0BtYWlsLmdtYWlsLmNvbQoK QnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jl c3FsLm9yZy9wZy9jb21taXRkaWZmLzZjNzI1MWRiMGNlMTJhODNkZDAzYzg0MGU3ZDBmZjc1MTZi MjcyMjkKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9pbmNsdWRlL2V4ZWN1dG9y L2V4ZWNFeHByLmggICAgICAgICAgICAgICB8ICAgMSArCnNyYy9wbC9wbHBnc3FsL3NyYy9leHBl Y3RlZC9wbHBnc3FsX2FycmF5Lm91dCB8ICAgOSArCnNyYy9wbC9wbHBnc3FsL3NyYy9wbF9leGVj LmMgICAgICAgICAgICAgICAgICB8IDM4MyArKysrKysrKysrKysrKysrKysrKysrLS0tLQpzcmMv cGwvcGxwZ3NxbC9zcmMvcGxwZ3NxbC5oICAgICAgICAgICAgICAgICAgfCAgMjIgKy0Kc3JjL3Bs L3BscGdzcWwvc3JjL3NxbC9wbHBnc3FsX2FycmF5LnNxbCAgICAgIHwgICA5ICsKc3JjL3Rvb2xz L3BnaW5kZW50L3R5cGVkZWZzLmxpc3QgICAgICAgICAgICAgIHwgICAyICsKNiBmaWxlcyBjaGFu Z2VkLCAzNjQgaW5zZXJ0aW9ucygrKSwgNjIgZGVsZXRpb25zKC0pCgo= --===============2084610451424400280==--