On Tue, 12 Oct 2021 at 23:07, Tomas Vondra
wrote:
> So yeah, there's an explicit 1GB limit per value, but having rows close
> to the 1GB limit is going to cause all sorts of unpredictable and rather
> painful issues :-(
Sounds worth mentioning in doc/src/sgml/limits.sgml
--
Simon Riggs
mailto:simon.ri...@enterprisedb.com>>
wrote:
>>
>> On Tue, 12 Oct 2021 at 08:14, Ram Pratap Maurya
>> mailto:ram.mau...@lavainternational.in>> wrote:
>>
>> > Confirm what is Avg/max size of these JSON docs in Postgres.
urya
> >> 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
On Tue, 12 Oct 2021 at 18:53, Michael Lewis wrote:
>
> On Tue, Oct 12, 2021 at 1:43 AM Simon Riggs
> wrote:
>>
>> On Tue, 12 Oct 2021 at 08:14, Ram Pratap Maurya
>> wrote:
>>
>> > Confirm what is Avg/max size of these JSON docs in Postgres.
>>
&g
Michael Lewis writes:
> 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.
The default behav
On Tue, Oct 12, 2021 at 1:43 AM Simon Riggs
wrote:
> On Tue, 12 Oct 2021 at 08:14, Ram Pratap Maurya
> 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
On Tue, 12 Oct 2021 at 08:14, Ram Pratap Maurya
wrote:
> Confirm what is Avg/max size of these JSON docs in Postgres.
JSON and JSONB datatypes can both be max 1GB in size.
--
Simon Riggshttp://www.EnterpriseDB.com/
Hi Team,
Confirm what is Avg/max size of these JSON docs in Postgres.
Regards,
Ram Pratap.
