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

[Nicolas Paris <niparisco@xxxxxxxxx>]

2016-06-07 14:31 GMT+02:00 David G. Johnston <david.g.johnston@xxxxxxxxx>:

On Tue, Jun 7, 2016 at 7:44 AM, Nicolas Paris <niparisco@xxxxxxxxx> 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 ?

Then I must build it with an external tool ?

​

 

​It doesn't matter that the data never actually is placed into a physical table.

David J.