Re: document json[b] limitation

From: Oleg Bartunov <obartunov(at)postgrespro(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: document json[b] limitation
Date: 2018-04-25 19:42:25
Message-ID: CAF4Au4w_L4LTJuuMDFrd-_OEo-OicFTdO6PJgxaMX12QJ6qggw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Wed, Apr 25, 2018 at 6:50 PM, Oleg Bartunov <obartunov(at)postgrespro(dot)ru> wrote:
> On Wed, Apr 25, 2018 at 2:12 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Oleg Bartunov <obartunov(at)postgrespro(dot)ru> writes:
>>> Attached is a small patch, which documents the maximum size of
>>> json[b] types. Probably, it's worth to patch previous releases, where
>>> the types were introduced.
>>
>> If you said "maximum size is 1GB", period, I'd believe it ... although
>> I'm pretty sure that general limitation is already documented elsewhere.
>> I don't believe that it's possible to make a 256 Gb jsonb. How will
>> that fit in the varlena header?
>
> Oops, it should be 256 Mb :)

patch attached.

>
>>
>> regards, tom lane
>>
>
>
>
> --
> Postgres Professional: http://www.postgrespro.com
> The Russian Postgres Company

--
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

Attachment Content-Type Size
json.sgml.patch application/octet-stream 442 bytes

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2018-04-25 22:55:44 Re: how does jsonb_set work?
Previous Message Oleg Bartunov 2018-04-25 15:50:51 Re: document json[b] limitation