Making jsonb_agg() faster

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v3, Patch count: 3, First patch: +518−425, All patches: +629−702

Topic

Performance

Tags

Created

2025-07-22 16:52:22

Last modified

2025-10-01 04:51:17 (1 month ago)

Latest email

2025-11-03 18:40:30 (yesterday)

Status

PG19-3 (2025-11-01 – 2025-11-30): Needs review

PG19-2 (2025-09-01 – 2025-09-30): Moved to different CF

Target version

Authors

Tom Lane (tgl)

Reviewers

Committer

Links

Emails

Making jsonb_agg() faster: First at 2025-07-22 16:37:02 by Tom Lane <tgl at sss.pgh.pa.us>
Latest at 2025-11-03 18:40:30 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (v3-0001-Revise-APIs-for-pushJsonbValue-and-associated-rou.patch) at 2025-11-02 20:56:49 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (v3-0001-Revise-APIs-for-pushJsonbValue-and-associated-rou.patch) at 2025-11-02 20:56:49 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v2-0001-Revise-APIs-for-pushJsonbValue-and-associated-rou.patch) at 2025-08-22 19:11:34 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v1-0001-minor-change-in-datum_to_jsonb_internal.no-cfbot) at 2025-08-15 17:21:01 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Revise-APIs-for-pushJsonbValue-and-associated-rou.patch) at 2025-07-22 16:37:02 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)

History

When	Who	What
2025-11-02 21:18:25	CFbot	Patch does not need rebase anymore
2025-11-02 06:50:23	CFbot	Patch needs rebase
2025-10-01 04:51:17	Tom Lane (tgl)	Moved from CF PG19-2 to CF PG19-3
2025-07-22 16:52:22	Tom Lane (tgl)	Attached mail thread [email protected]
2025-07-22 16:52:22	Tom Lane (tgl)	Created patch record