Re: Storing large large JSON objects in JSONB

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx
Subject: Re: Storing large large JSON objects in JSONB
From: Thomas Kellerer <shammat@xxxxxxx>
Date: Mon, 11 Jul 2022 14:11:24 +0200
In-reply-to: <CAOC+FBWRavHQWtQRJ_suSRjtDR9PrnDeRm9CWojr2ogYgDA7Ww@mail.gmail.com>
References: <CAOC+FBWRavHQWtQRJ_suSRjtDR9PrnDeRm9CWojr2ogYgDA7Ww@mail.gmail.com>
User-agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666

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.

Follow-Ups:
- Re: Storing large large JSON objects in JSONB
  - From: Wells Oliver

References:
- Storing large large JSON objects in JSONB
  - From: Wells Oliver

Prev by Date: Re: Improve "select count(*)" query - takes more than 30 mins for some large tables
Next by Date: Re: Storing large large JSON objects in JSONB
Previous by thread: Re: Storing large large JSON objects in JSONB
Next by thread: Re: Storing large large JSON objects in JSONB
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Home] [Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite Forum]

Powered by Linux