Making jsonb_agg() faster

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v4, Patch count: 3, First patch: +531−426, All patches: +642−703

Topic

Performance

Tags

Created

2025-07-22 16:52:22

Last modified

2025-12-02 01:28:59 (1 hour ago)

Latest email

2025-11-20 18:56:37 (1 week ago)

Status

PG19-4 (2026-01-01 – 2026-01-31): Needs review

PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF

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-20 18:56:37 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (v4-0001-Revise-APIs-for-pushJsonbValue-and-associated-rou.patch) at 2025-11-20 18:56:37 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (v4-0001-Revise-APIs-for-pushJsonbValue-and-associated-rou.patch) at 2025-11-20 18:56:37 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    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-12-02 01:28:59	Tom Lane (tgl)	Moved from CF PG19-3 to CF PG19-4
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 1060917.1753202222@sss.pgh.pa.us
2025-07-22 16:52:22	Tom Lane (tgl)	Created patch record