Re: Avg/max size of these JSON docs in Postgres - Mailing list pgsql-general

From Michael Lewis
Subject Re: Avg/max size of these JSON docs in Postgres
Date
Msg-id CAHOFxGo1MBesgpz_ooyoCjdkWHd9ZvemZ4r5=WeOg7VFTg_ACw@mail.gmail.com
Whole thread Raw
In response to Re: Avg/max size of these JSON docs in Postgres  (Simon Riggs <simon.riggs@enterprisedb.com>)
Responses Re: Avg/max size of these JSON docs in Postgres
List pgsql-general
On Tue, Oct 12, 2021 at 12:51 PM Simon Riggs <simon.riggs@enterprisedb.com> wrote:
On Tue, 12 Oct 2021 at 18:53, Michael Lewis <mlewis@entrata.com> wrote:
>
> On Tue, Oct 12, 2021 at 1:43 AM Simon Riggs <simon.riggs@enterprisedb.com> wrote:
>>
>> On Tue, 12 Oct 2021 at 08:14, Ram Pratap Maurya
>> <ram.maurya@lavainternational.in> wrote:
>>
>> > Confirm what is Avg/max size of these JSON docs in Postgres.
>>
>> JSON and JSONB datatypes can both be max 1GB in size.
>
> That is per row.

No, that is per column.

Yes, sorry. My attempt at clarification only muddled things. Each column within each row can be up to 1GB in size is how I understand the limit.

pgsql-general by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Avg/max size of these JSON docs in Postgres
Next
From: Adrian Klaver
Date:
Subject: Re: Fault with initcap