Re: Why is writing JSONB faster than just JSON?

Поиск
Список
Период
Сортировка
От Francisco Olarte
Тема Re: Why is writing JSONB faster than just JSON?
Дата
Msg-id CA+bJJbxo7kdUiwDi8fw+2bAjq28JaOZdnwyiaRWTVtJ5Af8OYw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Why is writing JSONB faster than just JSON?  (Mitar <mmitar@gmail.com>)
Ответы Re: Why is writing JSONB faster than just JSON?  (Mitar <mmitar@gmail.com>)
Список pgsql-general
Just a note:

On Fri, Apr 23, 2021 at 10:57 AM Mitar <mmitar@gmail.com> wrote:
> First, it is important to note that the JSON I am using contains
> primarily random strings as values, so not really something which is
> easy to compress. See example at [1].

A fast look at the link. It seems to be long string of random LOWER
CASE HEX DIGITS. A simple huffman coder can probably put it in 5 bits
per char, and a more sophisticated algorithm can probably approach 4.

FOS.



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: server process exited with code 1
Следующее
От: Mitar
Дата:
Сообщение: Re: Why is writing JSONB faster than just JSON?