Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #15083: [54000] ERROR: total size of jsonb array elementsexceeds the maximum of 268435455 bytes - Mailing list pgsql-bugs

From Vinston Pandiyan
Subject Re: BUG #15083: [54000] ERROR: total size of jsonb array elementsexceeds the maximum of 268435455 bytes
Date
Msg-id CACs8k4b7oywea9cg56PbK6QW6iAPFqBCFjkCpjvjbgBaJm0D7A@mail.gmail.com
Whole thread Raw
In response to Re: BUG #15083: [54000] ERROR: total size of jsonb array elementsexceeds the maximum of 268435455 bytes  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: BUG #15083: [54000] ERROR: total size of jsonb array elementsexceeds the maximum of 268435455 bytes  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Tree view
Is there way to fix this? i want to keep 500k rows in json or jsonb field?
please help me with this, it is possible to do it in postgres?

On Fri, Feb 23, 2018 at 12:42 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Friday, February 23, 2018, PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      15083
Logged by:          Vinston Pandiyan
Email address:      vinston.pandiyan@gmail.com
PostgreSQL version: 10.0
Operating system:   CentOS
Description:

Hi All,

When I try to update the rows into json array(of type jsonb). I am
getting following error.

[54000] ERROR: total size of jsonb array elements exceeds the maximum of
268435455 bytes

Is there any way to fix it or increase jsonb size?

 
Duplicate of 15079 

pgsql-bugs by date:

Previous
From: Kevin Bloch
Date:
Subject: maximum for auto_explain.log_min_duration doesn't seem to make sense
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #15083: [54000] ERROR: total size of jsonb array elementsexceeds the maximum of 268435455 bytes