Re: array size exceeds the maximum allowed (1073741823) when building a json

Josh Berkus <josh@agliodbs.com>

From: Josh Berkus <josh@agliodbs.com>
To: Nicolas Paris <niparisco@gmail.com>, "David G. Johnston" <david.g.johnston@gmail.com>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Date: 2016-06-07T13:03:20Z
Lists: pgsql-performance
On 06/07/2016 08:42 AM, Nicolas Paris wrote:
>     ​​You have to do something different.  Using multiple columns and/or
>     multiple rows might we workable.
> 
> 
> ​Certainly. Kind of disappointing, because I won't find any json builder
> as performant as postgresql.​

That's nice to hear.

> Will this 1GO restriction is supposed to increase in a near future ?​

Not planned, no.  Thing is, that's the limit for a field in general, not
just JSON; changing it would be a fairly large patch.  It's desireable,
but AFAIK nobody is working on it.

-- 
--
Josh Berkus
Red Hat OSAS
(any opinions are my own)