Re: Storing large large JSON objects in JSONB

From: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
To: Thomas Kellerer <shammat(at)gmx(dot)net>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Storing large large JSON objects in JSONB
Date: 2022-07-11 16:25:06
Message-ID: CAOC+FBUT7YSGWV3KR29fASRMCBDXvFXSwTsnTS_=z=8ZKf+eVQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

What exactly does that mean? The upper limit at which TOAST is used for
storage, or what? We certainly have objects larger than 256MB in JSONB
columns.

On Mon, Jul 11, 2022 at 5:11 AM Thomas Kellerer <shammat(at)gmx(dot)net> wrote:

> Wells Oliver schrieb am 09.07.2022 um 21:37:
> > We have a couple of tables where we like to store very large JSON
> > objects in a JSONB column.
> Note, that the upper limit for a single jsonb value is 255MB
> Not 1GB as it is e.g. the case for text or json.
>
>
>
>
>

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Thomas Kellerer 2022-07-11 17:49:43 Re: Storing large large JSON objects in JSONB
Previous Message Thomas Kellerer 2022-07-11 12:11:24 Re: Storing large large JSON objects in JSONB