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 CAHOFxGobn9REnhU0dd=yRvPQ5a_qj97GRr1vxCOdafOfUTjd+A@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
Re: Avg/max size of these JSON docs in Postgres
List pgsql-general
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.

Just to confirm- The compression associated with TOAST is only if the value can fit in line, right? Columns don't get stored out-of-line in a toast table as a compressed value as I read the documentation. I suppose that would make reads a bit crazy.

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Aw: Re: Fault with initcap
Next
From: Tom Lane
Date:
Subject: Re: Avg/max size of these JSON docs in Postgres