Thread: BUG #15083: [54000] ERROR: total size of jsonb array elements exceedsthe maximum of 268435455 bytes
BUG #15083: [54000] ERROR: total size of jsonb array elements exceedsthe maximum of 268435455 bytes
From
PG Bug reporting form
Date:
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? Thanks
Re: BUG #15083: [54000] ERROR: total size of jsonb array elementsexceeds the maximum of 268435455 bytes
From
"David G. Johnston"
Date:
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
Re: BUG #15083: [54000] ERROR: total size of jsonb array elementsexceeds the maximum of 268435455 bytes
From
Vinston Pandiyan
Date:
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
Re: BUG #15083: [54000] ERROR: total size of jsonb array elementsexceeds the maximum of 268435455 bytes
From
"David G. Johnston"
Date:
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?
For the typical user, no, there is no way to get rid of the limitation - you will need to decide how you want to go about avoiding it.
David J.
Re: BUG #15083: [54000] ERROR: total size of jsonb array elementsexceeds the maximum of 268435455 bytes
From
Vinston Pandiyan
Date:
if you can suggest any workaround this? or it is possible to compress the data and store?
On Fri, Feb 23, 2018 at 1:48 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
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?For the typical user, no, there is no way to get rid of the limitation - you will need to decide how you want to go about avoiding it.David J.