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.96) (envelope-from ) id 1vSI5G-00Ao9q-0T for pgsql-committers@arkaria.postgresql.org; Sun, 07 Dec 2025 16:58:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vSI5E-00Dg6t-2R for pgsql-committers@arkaria.postgresql.org; Sun, 07 Dec 2025 16:58:05 +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.96) (envelope-from ) id 1vSI4K-00DeTz-2H for pgsql-committers@lists.postgresql.org; Sun, 07 Dec 2025 16:57:09 +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 1vSI4H-003cTT-2Z for pgsql-committers@lists.postgresql.org; Sun, 07 Dec 2025 16:57:07 +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.96) (envelope-from ) id 1vSI4I-006XhX-1H for pgsql-committers@lists.postgresql.org; Sun, 07 Dec 2025 16:57:06 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vSI4G-003IEj-14 for pgsql-committers@lists.postgresql.org; Sun, 07 Dec 2025 16:57:04 +0000 Content-Type: multipart/mixed; boundary="===============6545097706089704694==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Remove fundamentally-redundant processing in jsonb_agg() et al. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sun, 07 Dec 2025 16:57:04 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6545097706089704694== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UmVtb3ZlIGZ1bmRhbWVudGFsbHktcmVkdW5kYW50IHByb2Nlc3NpbmcgaW4ganNvbmJfYWdnKCkg ZXQgYWwuCgpUaGUgdmFyaW91cyB2YXJpYW50cyBvZiBqc29uYl9hZ2coKSBvcGVyYXRlIGFzIGZv bGxvd3MsCmZvciBlYWNoIGFnZ3JlZ2F0ZSBpbnB1dCB2YWx1ZToKCjEuIEJ1aWxkIGEgSnNvbmJW YWx1ZSB0cmVlIHJlcHJlc2VudGF0aW9uIG9mIHRoZSBpbnB1dCB2YWx1ZS4KMi4gRmxhdHRlbiB0 aGUgSnNvbmJWYWx1ZSB0cmVlIGludG8gYSBKc29uYiBpbiBvbi1kaXNrIGZvcm1hdC4KMy4gSXRl cmF0ZSB0aHJvdWdoIHRoZSBKc29uYiwgYnVpbGRpbmcgYSBKc29uYlZhbHVlIHRoYXQgaXMgcGFy dApvZiB0aGUgYWdncmVnYXRlJ3Mgc3RhdGUgc3RvcmVkIGluIGFnZ2NvbnRleHQsIGJ1dCBpcyBv dGhlcndpc2UKaWRlbnRpY2FsIHRvIHdoYXQgcGhhc2UgMSBidWlsdC4KClRoaXMgaXMgdmVyeSBz bGlnaHRseSBsZXNzIHNpbGx5IHRoYW4gaXQgc291bmRzLCBiZWNhdXNlIHBoYXNlIDEKaW52b2x2 ZXMgY2FsbGluZyBub24tSlNPTkIgY29kZSBzdWNoIGFzIGRhdGF0eXBlIG91dHB1dCBmdW5jdGlv bnMsCndoaWNoIGFyZSBsaWtlbHkgdG8gbGVhayBtZW1vcnksIGFuZCB3ZSBkb24ndCB3YW50IHRv IGxlYWsgaW50byB0aGUKYWdnY29udGV4dC4gIE5vbmV0aGVsZXNzLCBwaGFzZXMgMiBhbmQgMyBh cmUgYWNjb21wbGlzaGluZyBleGFjdGx5Cm5vdGhpbmcgdGhhdCBpcyB1c2VmdWwgaWYgd2UgY2Fu IG1ha2UgcGhhc2UgMSBwdXQgdGhlIEpzb25iVmFsdWUKdHJlZSB3aGVyZSB3ZSBuZWVkIGl0LiAg V2UgY291bGQgcHJvYmFibHkgZG8gdGhhdCB3aXRoIGEgYnVuY2ggb2YKTWVtb3J5Q29udGV4dFN3 aXRjaFRvJ3MsIGJ1dCB3aGF0IHNlZW1zIG1vcmUgcm9idXN0IGlzIHRvIGdpdmUKcHVzaEpzb25i VmFsdWUgdGhlIHJlc3BvbnNpYmlsaXR5IG9mIGJ1aWxkaW5nIHRoZSBKc29uYlZhbHVlIHRyZWUK aW4gYSBzcGVjaWZpZWQgbm9uLWN1cnJlbnQgbWVtb3J5IGNvbnRleHQuICBUaGUgcHJldmlvdXMg cGF0Y2gKY3JlYXRlZCB0aGUgaW5mcmFzdHJ1Y3R1cmUgZm9yIHRoYXQsIGFuZCB0aGlzIHBhdGNo IHNpbXBseSBtYWtlcwp0aGUgYWdncmVnYXRlIGZ1bmN0aW9ucyB1c2UgaXQgYW5kIHRoZW4gcmlw cyBvdXQgcGhhc2VzIDIgYW5kIDMuCgpGb3IgbWUsIHRoaXMgbWFrZXMganNvbmJfYWdnKCkgd2l0 aCBhIHRleHQgY29sdW1uIGFzIGlucHV0IHJ1bgphYm91dCAyWCBmYXN0ZXIgdGhhbiBiZWZvcmUu ICBJdCdzIG5vdCB5ZXQgb24gcGFyIHdpdGgganNvbl9hZ2coKSwKYnV0IHRoaXMgcmVtb3ZlcyBh IHdob2xlIGxvdCBvZiB0aGUgZGlmZmVyZW5jZS4KCkF1dGhvcjogVG9tIExhbmUgPHRnbEBzc3Mu cGdoLnBhLnVzPgpSZXZpZXdlZC1ieTogamlhbiBoZSA8amlhbi51bml2ZXJzYWxpdHlAZ21haWwu Y29tPgpSZXZpZXdlZC1ieTogQ2hhbyBMaSA8bGkuZXZhbi5jaGFvQGdtYWlsLmNvbT4KRGlzY3Vz c2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8xMDYwOTE3LjE3NTMyMDIyMjJAc3NzLnBnaC5wYS51 cwoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0 Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2I2MWFhNzZlNDU4NWI0YjcxMDk4YjA5OTBiMjA4ODEz YTg1ZGJiZjUKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL3V0aWxz L2FkdC9qc29uYi5jIHwgMzAzICsrKysrKystLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLQoxIGZpbGUgY2hhbmdlZCwgNDUgaW5zZXJ0aW9ucygrKSwgMjU4IGRlbGV0aW9ucygtKQoK --===============6545097706089704694==--