2016-06-07 14:39 GMT+02:00 David G. Johnston <david.g.johns...@gmail.com>:
> On Tue, Jun 7, 2016 at 8:36 AM, Nicolas Paris <nipari...@gmail.com> wrote: > >> 2016-06-07 14:31 GMT+02:00 David G. Johnston <david.g.johns...@gmail.com> >> : >> >>> On Tue, Jun 7, 2016 at 7:44 AM, Nicolas Paris <nipari...@gmail.com> >>> wrote: >>> >>>> Hello, >>>> >>>> I run a query transforming huge tables to a json document based on a >>>> period. >>>> It works great for a modest period (little dataset). >>>> However, when increasing the period (huge dataset) I get this error: >>>> >>>> SQL ERROR[54000] >>>> ERROR: array size exceeds the maximum allowed (1073741823) >>>> >>>> https://www.postgresql.org/about/ >>> >>> Maximum Field Size: 1 GB >>> >> >> It means a json cannot exceed 1GB in postgresql, right ? >> > > Yes > > >> Then I must build it with an external tool ? >> >> >> > > 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. Will this 1GO restriction is supposed to increase in a near future ? > David J. > >
