Re: BUG #15083: [54000] ERROR: total size of jsonb array elementsexceeds the maximum of 268435455 bytes

Поиск
Список
Период
Сортировка
От Vinston Pandiyan
Тема Re: BUG #15083: [54000] ERROR: total size of jsonb array elementsexceeds the maximum of 268435455 bytes
Дата
Msg-id CACs8k4a_bz17buZX5v5HwyunuB6A32N0uNje3WnLHCbEMeKgOw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #15083: [54000] ERROR: total size of jsonb array elementsexceeds the maximum of 268435455 bytes  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-bugs
Дерево обсуждения
if you can suggest any workaround this? or it is possible to compress the data and store?

On Fri, Feb 23, 2018 at 1:48 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Fri, Feb 23, 2018 at 11:45 AM, Vinston Pandiyan <vinston.pandiyan@gmail.com> wrote:
Is there way to fix this? i want to keep 500k rows in json or jsonb field?
please help me with this, it is possible to do it in postgres?

​For the typical user, no, there is no way to get rid of the limitation - you will need to decide how you want to go about avoiding it.

David J.


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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: maximum for auto_explain.log_min_duration doesn't seem to make sense
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15082: PostgreSQL 11 dev bug with window range partition by QUERY