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

Поиск
Список
Период
Сортировка
От Xtra Coder
Тема Re: Performance issue: jsonb_object_agg() is twice slower than to_jsonb()
Дата
Msg-id CAL2enjJ_Ed2bbu6i76g42=HyD4N_cVFN=JTXCTOYhv0xbPF6TQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performance issue: jsonb_object_agg() is twice slower than to_jsonb()  (Vitaly Burovoy <vitaly.burovoy@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: juergen+postgresql@strobel.info
Дата:
Сообщение: BUG #14321: pg_basebackup --xlog-method=stream fails
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #14321: pg_basebackup --xlog-method=stream fails