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
On 10/12/21 21:21, Michael Lewis wrote:
On Tue, Oct 12, 2021 at 12:51 PM Simon Riggs
mailto:simon.ri...@enterprisedb.com>> wrote:
On Tue, 12 Oct 2021 at 18:53, Michael Lewis mailto:mle...@entrata.com>> wrote:
>
> On Tue, Oct 12, 2021 at 1:43 AM Simon Riggs
mailto:simon.ri...@e
On Tue, Oct 12, 2021 at 12:51 PM Simon Riggs
wrote:
> On Tue, 12 Oct 2021 at 18:53, Michael Lewis wrote:
> >
> > On Tue, Oct 12, 2021 at 1:43 AM Simon Riggs <
> simon.ri...@enterprisedb.com> wrote:
> >>
> >> On Tue, 12 Oct 2021 at 08:14, Ram Pratap Maurya
> >> wrote:
> >>
> >> > Confirm what is
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.
>>
>> JSON and JSONB datatypes can both be max 1GB in
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 confirm- The compression associa
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/
