Re: JSON vs. JSONB storage size

Поиск
Список
Период
Сортировка
От Dmitry Dolgov
Тема Re: JSON vs. JSONB storage size
Дата
Msg-id CA+q6zcVvJoBzhPOK9ouy_TgqwDBWcgvedxPVf4G7B4iRq8AAYg@mail.gmail.com
обсуждение исходный текст
Ответ на JSON vs. JSONB storage size  (Thomas Kellerer <spam_eater@gmx.net>)
Список pgsql-general
> On Fri, Oct 11, 2019 at 1:40 PM Thomas Kellerer <spam_eater@gmx.net> wrote:
>
> I am a bit surprised by this (not because the jsonb sizes are generally
> bigger, but that the string value takes less space)
>
> Is this caused by the fact that a string value compresses better internally?

Those jsonb objects are quite small, so it could be that an alignment kicks in,
since as far as I remember, jsonb header and data should be aligned by 4 byte
boundary.



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Issues with PAM : log that it failed, whether it actually failed or not
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: JSON vs. JSONB storage size