Re: Performance issue: jsonb_object_agg() is twice slower than to_jsonb()

From: Xtra Coder <xtracoder(at)gmail(dot)com>
To: Vitaly Burovoy <vitaly(dot)burovoy(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Performance issue: jsonb_object_agg() is twice slower than to_jsonb()
Date: 2016-09-09 19:11:54
Message-ID: CAL2enjJ_Ed2bbu6i76g42=HyD4N_cVFN=JTXCTOYhv0xbPF6TQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2016-09-09 22:09:02 Re: BUG #14321: pg_basebackup --xlog-method=stream fails
Previous Message juergen+postgresql 2016-09-09 16:58:46 BUG #14321: pg_basebackup --xlog-method=stream fails