Re: Making jsonb_agg() faster
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Chao Li <li.evan.chao@gmail.com>
Cc: jian he <jian.universality@gmail.com>, pgsql-hackers@lists.postgresql.org
Date: 2025-11-02T20:56:49Z
Lists: pgsql-hackers
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Fix jsonb_object_agg crash after eliminating null-valued pairs.
- ef5f559b95e2 19 (unreleased) landed
-
Micro-optimize datatype conversions in datum_to_jsonb_internal.
- 005a2907dc30 19 (unreleased) landed
-
Remove fundamentally-redundant processing in jsonb_agg() et al.
- b61aa76e4585 19 (unreleased) landed
-
Revise APIs for pushJsonbValue() and associated routines.
- 0986e95161ce 19 (unreleased) landed
-
Add a macro for the declared typlen of type timetz.
- 3628af42107d 19 (unreleased) landed
Attachments
- v3-0001-Revise-APIs-for-pushJsonbValue-and-associated-rou.patch (text/x-diff) patch v3-0001
- v3-0002-Remove-fundamentally-redundant-processing-in-json.patch (text/x-diff) patch v3-0002
- v3-0003-Micro-optimize-datatype-conversions-in-datum_to_j.patch (text/x-diff) patch v3-0003
PFA v3, rebased over 8a27d418f, no substantive changes whatever. regards, tom lane