Postgres Pro
Downloads
Home   >   mailing lists

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

From Simon Riggs
Subject Re: Avg/max size of these JSON docs in Postgres
Date
Msg-id CANbhV-ESaegZ0dgWRWS6bd_E-GWZOmcV_YCo85F802cUoz-rDg@mail.gmail.com
Whole thread Raw
In response to Re: Avg/max size of these JSON docs in Postgres  (Michael Lewis <mlewis@entrata.com>)
Responses Re: Avg/max size of these JSON docs in Postgres
List pgsql-general
Tree view 
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.

-- 
Simon Riggs                http://www.EnterpriseDB.com/

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Avg/max size of these JSON docs in Postgres
Next
From: Michael Lewis
Date:
Subject: Re: Avg/max size of these JSON docs in Postgres