Re: Why is writing JSONB faster than just JSON?

From: Francisco Olarte <folarte(at)peoplecall(dot)com>
To: Mitar <mmitar(at)gmail(dot)com>
Cc: Dmitry Dolgov <9erthalion6(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Why is writing JSONB faster than just JSON?
Date: 2021-04-23 17:28:00
Message-ID: CA+bJJbxo7kdUiwDi8fw+2bAjq28JaOZdnwyiaRWTVtJ5Af8OYw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Just a note:

On Fri, Apr 23, 2021 at 10:57 AM Mitar <mmitar(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mitar 2021-04-23 17:33:34 Re: Why is writing JSONB faster than just JSON?
Previous Message Tom Lane 2021-04-23 16:36:41 Re: server process exited with code 1