Re: Making jsonb_agg() faster

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Making jsonb_agg() faster
Дата
Msg-id CAHyXU0w+_5ASOB1-cctDWYYNSnUirU_=NN8uxhQ-954h1LHYnw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Making jsonb_agg() faster  (Merlin Moncure <mmoncure@gmail.com>)
Список 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 по дате отправления: