| From: | Nicolas Paris <niparisco(at)gmail(dot)com> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | pgsql-performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: array size exceeds the maximum allowed (1073741823) when building a json |
| Date: | 2016-06-07 12:36:46 |
| Message-ID: | CA+ssMOT04Wg+OGfSc5AUk8nVQOxkVS6=CD-h7bH-pAH-ix50cw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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 ?
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.
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2016-06-07 12:39:18 | Re: array size exceeds the maximum allowed (1073741823) when building a json |
| Previous Message | David G. Johnston | 2016-06-07 12:31:05 | Re: array size exceeds the maximum allowed (1073741823) when building a json |