Re: Why is writing JSONB faster than just JSON? - Mailing list pgsql-general

From Francisco Olarte
Subject Re: Why is writing JSONB faster than just JSON?
Date
Msg-id CA+bJJbxo7kdUiwDi8fw+2bAjq28JaOZdnwyiaRWTVtJ5Af8OYw@mail.gmail.com
Whole thread Raw
In response to Re: Why is writing JSONB faster than just JSON?  (Mitar <mmitar@gmail.com>)
Responses Re: Why is writing JSONB faster than just JSON?  (Mitar <mmitar@gmail.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: server process exited with code 1
Next
From: Mitar
Date:
Subject: Re: Why is writing JSONB faster than just JSON?