Re: Why is writing JSONB faster than just JSON?

From: Mitar <mmitar(at)gmail(dot)com>
To: Francisco Olarte <folarte(at)peoplecall(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:33:34
Message-ID: CAKLmikNo-WY044Qx=iXvMfYzyGOVBD48zFRXA5drt8BQxy5vTg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

On Fri, Apr 23, 2021 at 10:28 AM Francisco Olarte
<folarte(at)peoplecall(dot)com> wrote:
> 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.

But this compression-ility would apply to both JSONB and JSON column
types, no? Moreover, it looks like JSONB column type ends up larger on
disk.

Mitar

--
http://mitar.tnode.com/
https://twitter.com/mitar_m

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Olarte 2021-04-23 17:48:41 Re: Why is writing JSONB faster than just JSON?
Previous Message Francisco Olarte 2021-04-23 17:28:00 Re: Why is writing JSONB faster than just JSON?