Re: Performance issue: jsonb_object_agg() is twice slower than to_jsonb() - Mailing list pgsql-bugs

From Xtra Coder
Subject Re: Performance issue: jsonb_object_agg() is twice slower than to_jsonb()
Date
Msg-id CAL2enjJ_Ed2bbu6i76g42=HyD4N_cVFN=JTXCTOYhv0xbPF6TQ@mail.gmail.com
Whole thread Raw
In response to Re: Performance issue: jsonb_object_agg() is twice slower than to_jsonb()  (Vitaly Burovoy <vitaly.burovoy@gmail.com>)
List pgsql-bugs
Thanks for analysis. So, it was my mistake to copy/paste usage of '
jsonb_object_agg()' from another use-case expecting better performance when
used in non-agg context. Yes, jsonb_build_object() is more appropriate in
this case - however it appeared in 9.5 and I was not aware about it,
therefore was using obsolete approach.

pgsql-bugs by date:

Previous
From: juergen+postgresql@strobel.info
Date:
Subject: BUG #14321: pg_basebackup --xlog-method=stream fails
Next
From: Michael Paquier
Date:
Subject: Re: BUG #14321: pg_basebackup --xlog-method=stream fails