Postgres Pro
Downloads
Home   >   mailing lists

Re: Storing large large JSON objects in JSONB - Mailing list pgsql-admin

From Thomas Kellerer
Subject Re: Storing large large JSON objects in JSONB
Date
Msg-id 16681dbd-639c-0d38-d3ee-28c808c05a4d@gmx.net
Whole thread Raw
In response to Storing large large JSON objects in JSONB  (Wells Oliver <wells.oliver@gmail.com>)
Responses Re: Storing large large JSON objects in JSONB
List pgsql-admin
Tree view 
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.

pgsql-admin by date:

Previous
From: Raj kumar
Date:
Subject: Re: Improve "select count(*)" query - takes more than 30 mins for some large tables
Next
From: Wells Oliver
Date:
Subject: Re: Storing large large JSON objects in JSONB