Re: Storing large large JSON objects in JSONB

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема Re: Storing large large JSON objects in JSONB
Дата
Msg-id CAOC+FBUT7YSGWV3KR29fASRMCBDXvFXSwTsnTS_=z=8ZKf+eVQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Storing large large JSON objects in JSONB  (Thomas Kellerer <shammat@gmx.net>)
Ответы Re: Storing large large JSON objects in JSONB  (Thomas Kellerer <shammat@gmx.net>)
Список 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@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.






--

В списке pgsql-admin по дате отправления:

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: Storing large large JSON objects in JSONB
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: Storing large large JSON objects in JSONB