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

David G. Johnston <david.g.johnston@gmail.com>

From: "David G. Johnston" <david.g.johnston@gmail.com>

To: Nicolas Paris <niparisco@gmail.com>

Cc: pgsql-performance <pgsql-performance@postgresql.org>

Date: 2016-06-07T12:31:05Z

Lists: pgsql-performance

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