Re: [GENERAL] JSONB performance enhancement for 9.6

2015-11-28 Thread John R Pierce
On 11/28/2015 6:27 PM, Tom Smith wrote: Is there a plan for 9.6 to resolve the issue of very slow query/retrieval of jsonb fields when there are large number (maybe several thousands) of top level keys. Currently, if I save a large json document with top level keys of thousands and query/retrie

[GENERAL] JSONB performance enhancement for 9.6

2015-11-28 Thread Tom Smith
Hello: Is there a plan for 9.6 to resolve the issue of very slow query/retrieval of jsonb fields when there are large number (maybe several thousands) of top level keys. Currently, if I save a large json document with top level keys of thousands and query/retrieve field values, the whole document

Re: [GENERAL] DISTINCT in STRING_AGG

2015-11-28 Thread John J. Turner
On Nov 28, 2015, at 1:35 PM, Sterpu Victor wrote: > Hello > > Can I make a distinct STRING_AGG? > This is my query : > SELECT atjs.id, STRING_AGG(CAST(aqjs1.id AS VARCHAR), ',' ORDER BY > aqjs1.to_left) AS children > FROM administration.ad_query_join_select atjs > JOIN administration.ad_query

[GENERAL] DISTINCT in STRING_AGG

2015-11-28 Thread Sterpu Victor
Hello Can I make a distinct STRING_AGG? This is my query : SELECT atjs.id, STRING_AGG(CAST(aqjs1.id AS VARCHAR), ',' ORDER BY aqjs1.to_left) AS children FROM administration.ad_query_join_select atjs JOIN administration.ad_query aq ON (aq.id=atjs.id_ad_query) LEFT JOIN administration.ad_query_jo