Re: [PERFORM] jsonb_agg performance

2016-01-29 Thread Andrew Dunstan
On 01/29/2016 05:06 PM, jflem...@kispring.com wrote: The jsonb_agg function seems to have significantly worse performance than its json_agg counterpart: => explain analyze select pa.product_id, jsonb_agg(attributes) from product_attributes2 pa group by pa.product_id; QUERY PLAN

[PERFORM] jsonb_agg performance

2016-01-29 Thread jfleming
The jsonb_agg function seems to have significantly worse performance than its json_agg counterpart: => explain analyze select pa.product_id, jsonb_agg(attributes) from product_attributes2 pa group by pa.product_id;   QUERY PLAN --