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

public inbox for [email protected]  
help / color / mirror / Atom feed

From: Nicolas Paris <[email protected]>
To: David G. Johnston <[email protected]>
Cc: pgsql-performance <[email protected]>
Subject: Re: array size exceeds the maximum allowed (1073741823) when building a json
Date: Tue, 7 Jun 2016 14:36:46 +0200
Message-ID: <CA+ssMOT04Wg+OGfSc5AUk8nVQOxkVS6=CD-h7bH-pAH-ix50cw@mail.gmail.com> (raw)
In-Reply-To: <CAKFQuwbjwyaaFUOEzxoYCBDm25ujOayCniwiWimPML_A_VaGYA@mail.gmail.com>
References: <CA+ssMORBYVFxedSXVVxL5VPeo=9AbYRQ-zbpuKJm6vEjmJ1CFA@mail.gmail.com>
	<CAKFQuwbjwyaaFUOEzxoYCBDm25ujOayCniwiWimPML_A_VaGYA@mail.gmail.com>
List-Unsubscribe:  <mailto:[email protected]?body=unsub%20pgsql-performance>

2016-06-07 14:31 GMT+02:00 David G. Johnston <[email protected]>:

> On Tue, Jun 7, 2016 at 7:44 AM, Nicolas Paris <[email protected]> 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.
>
>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: array size exceeds the maximum allowed (1073741823) when building a json
  In-Reply-To: <CA+ssMOT04Wg+OGfSc5AUk8nVQOxkVS6=CD-h7bH-pAH-ix50cw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox