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

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.

David J.