| From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Making jsonb_agg() faster |
| Date: | 2025-07-22 21:02:27 |
| Message-ID: | CAHyXU0w+_5ASOB1-cctDWYYNSnUirU_=NN8uxhQ-954h1LHYnw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Jul 22, 2025 at 11:43 AM Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
> On Tue, Jul 22, 2025 at 10:37 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2025-07-22 21:11:04 | Re: index prefetching |
| Previous Message | Tom Lane | 2025-07-22 20:54:45 | Re: support create index on virtual generated column. |