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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #15079: [54000] ERROR: total size of jsonb array elementsexceeds the maximum of 268435455 bytes
Дата
Msg-id CAKFQuwZZ95W5JxQ_fgzdPONeCenUJ59-RB_zQtSQ8puKUJEJiQ@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #15079: [54000] ERROR: total size of jsonb array elements exceedsthe maximum of 268435455 bytes  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
Дерево обсуждения
On Thu, Feb 22, 2018 at 1:58 PM, PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      15079
Logged by:           Revathi
Email address:      revs.subdu@gmail.com
PostgreSQL version: 10.0
Operating system:   CentoS
Description:

Hi,

When I try to update the column with large json value (of type jsonb). I am
getting following error.

[54000] ERROR: total size of jsonb array elements exceeds the maximum of
268435455 bytes

Is there any way to fix it or increase jsonb size?

This isn't a bug and the only option to increase it is to change "JENTRY_OFFLENMASK" in src/include/utils/jsonb.h (and while I'm not a hacker I doubt its that simple).

If you are willing to go down the hacker path you should post a new message to the -hackers list discussing your desire.

Otherwise the limit here seems to be due to having too many array elements - converting each element into a single database row will probably work and likely will perform considerably better regardless, though its difficult to know for sure without more detail about the structure of the json.

David J.

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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15079: [54000] ERROR: total size of jsonb array elements exceedsthe maximum of 268435455 bytes
Следующее
От: 趙明春
Дата:
Сообщение: Re: BUG #15076: postmaster crashes unexpectedly when using up arrowkey in psql command