Re: array size exceeds the maximum allowed (1073741823) when building a json

2016-06-07 14:39 GMT+02:00 David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>:

> On Tue, Jun 7, 2016 at 8:36 AM, Nicolas Paris <niparisco(at)gmail(dot)com> wrote:
>
>> 2016-06-07 14:31 GMT+02:00 David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
>> :
>>
>>> On Tue, Jun 7, 2016 at 7:44 AM, Nicolas Paris <niparisco(at)gmail(dot)com>
>>> wrote:
>>>
>>>> Hello,
>>>>
>>>> I run a query transforming huge tables to a json document based on a period.
>>>> It works great for a modest period (little dataset).
>>>> However, when increasing the period (huge dataset) I get this error:
>>>>
>>>> SQL ERROR[54000]
>>>> ERROR: array size exceeds the maximum allowed (1073741823)
>>>>
>>>> ​https://www.postgresql.org/about/​
>>>
>>> ​Maximum Field Size: 1 GB​
>>>
>>
>> It means a json cannot exceed 1GB in postgresql, right ?
>>
>
> ​Yes​
>
>
>> Then I must build it with an external tool ?
>> ​
>>
>>
>
> ​​You have to do something different. Using multiple columns and/or
> multiple rows might we workable.
>

​Certainly. Kind of disappointing, because I won't find any json builder as
performant as postgresql.​

​

Will this 1GO restriction is supposed to increase in a near future ?​

> David J.
>
>