Re: Making jsonb_agg() faster - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: Making jsonb_agg() faster
Date
Msg-id CAHyXU0w+_5ASOB1-cctDWYYNSnUirU_=NN8uxhQ-954h1LHYnw@mail.gmail.com
Whole thread Raw
In response to Re: Making jsonb_agg() faster  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
On Tue, Jul 22, 2025 at 11:43 AM Merlin Moncure <mmoncure@gmail.com> wrote:
On Tue, Jul 22, 2025 at 10:37 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:

Thoughts?

Really excited about this -- I'll do some testing.  Performance of serialization (generating json output from non json data) is the main reason I still recommend json...jsonb is better in most other cases, but serialization performance is extremely important.  

Performance improvement is pretty dramatic, down from 300%+ to ~ 40% -- it's pretty reliable 40% on all output bound cases FWICT.

merlin

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: support create index on virtual generated column.
Next
From: Andres Freund
Date:
Subject: Re: index prefetching