From: Thomas Kellerer <shammat@gmx.net>
To: pgsql-admin@lists.postgresql.org
Cc: Wells Oliver <wells.oliver@gmail.com>
Subject: Re: Storing large large JSON objects in JSONB
Date: Mon, 11 Jul 2022 19:49:43 +0200
Message-ID: <b193cc6f-6883-b5ea-40a5-7cfd20b299ae@gmx.net> (raw)
In-Reply-To: <CAOC+FBUT7YSGWV3KR29fASRMCBDXvFXSwTsnTS_=z=8ZKf+eVQ@mail.gmail.com>
References: <CAOC+FBWRavHQWtQRJ_suSRjtDR9PrnDeRm9CWojr2ogYgDA7Ww@mail.gmail.com>
<16681dbd-639c-0d38-d3ee-28c808c05a4d@gmx.net>
<CAOC+FBUT7YSGWV3KR29fASRMCBDXvFXSwTsnTS_=z=8ZKf+eVQ@mail.gmail.com>
Wells Oliver schrieb am 11.07.2022 um 18:25:
>> On Mon, Jul 11, 2022 at 5:11 AM Thomas Kellerer <shammat@gmx.net <mailto:shammat@gmx.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.
> 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.
Hmm, that's strange, because when I try to create a JSONB value that is
larger than 256MB I get the following error:
ERROR: total size of jsonb object elements exceeds the maximum of 268435455 bytes
Are you sure you are using jsonb, not json maybe?
To my knowledge the json data type does not have this limit.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: shammat@gmx.net, pgsql-admin@lists.postgresql.org, wells.oliver@gmail.com
Subject: Re: Storing large large JSON objects in JSONB
In-Reply-To: <b193cc6f-6883-b5ea-40a5-7cfd20b299ae@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox