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 CACs8k4a_bz17buZX5v5HwyunuB6A32N0uNje3WnLHCbEMeKgOw@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>)
List pgsql-bugs
Tree view
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:
On Fri, Feb 23, 2018 at 11:45 AM, Vinston Pandiyan <vinston.pandiyan@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.


pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: maximum for auto_explain.log_min_duration doesn't seem to make sense
Next
From: Tom Lane
Date:
Subject: Re: BUG #15082: PostgreSQL 11 dev bug with window range partition by QUERY