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. David J.