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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: array size exceeds the maximum allowed (1073741823) when building a json
Дата
Msg-id CAKFQuwZEkX6o2mv2Ekqp8DpAs9F0bMsBnvQxzJGUr+SS6t2yTg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: array size exceeds the maximum allowed (1073741823) when building a json  (Nicolas Paris <niparisco@gmail.com>)
Ответы Re: array size exceeds the maximum allowed (1073741823) when building a json  (Nicolas Paris <niparisco@gmail.com>)
Список pgsql-performance
Дерево обсуждения
On Tue, Jun 7, 2016 at 8:36 AM, Nicolas Paris <niparisco@gmail.com> wrote:
2016-06-07 14:31 GMT+02:00 David G. Johnston <david.g.johnston@gmail.com>:
On Tue, Jun 7, 2016 at 7:44 AM, Nicolas Paris <niparisco@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)


​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.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Nicolas Paris
Дата:
Сообщение: Re: array size exceeds the maximum allowed (1073741823) when building a json
Следующее
От: Nicolas Paris
Дата:
Сообщение: Re: array size exceeds the maximum allowed (1073741823) when building a json