Quick Links

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

From:	"David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To:	Vinston Pandiyan <vinston(dot)pandiyan(at)gmail(dot)com>
Cc:	"pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject:	Re: BUG #15083: [54000] ERROR: total size of jsonb array elements exceeds the maximum of 268435455 bytes
Date:	2018-02-23 18:48:54
Message-ID:	CAKFQuwYQFLmWM7DHxNjnLcpejz+rqEamNTJTgamf9QZPphfc6w@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-bugs

On Fri, Feb 23, 2018 at 11:45 AM, Vinston Pandiyan <
vinston(dot)pandiyan(at)gmail(dot)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.

	From	Date	Subject
Next Message	David G. Johnston	2018-02-23 19:02:58	Re: maximum for auto_explain.log_min_duration doesn't seem to make sense
Previous Message	Vinston Pandiyan	2018-02-23 18:45:27	Re: BUG #15083: [54000] ERROR: total size of jsonb array elements exceeds the maximum of 268435455 bytes