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

[David G. Johnston]

On Tue, Jun 7, 2016 at 7:44 AM, Nicolas Paris <nipari...@gmail.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 doesn't matter that the data never actually is placed into a physical
table.

David J.