Re: [GENERAL] Insert performance and disk usage in JSON vs JSONB - Mailing list pgsql-general

From Dmitry Dolgov
Subject Re: [GENERAL] Insert performance and disk usage in JSON vs JSONB
Date
Msg-id CA+q6zcUKhM_tg2Rrw2Y1fZvVsdN0p=QUC2Sr+=RuvYuPm8JYFg@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Insert performance and disk usage in JSON vs JSONB  (Ronny Abraham <rabraham@kns.com>)
Responses Re: [GENERAL] Insert performance and disk usage in JSON vs JSONB  (Ronny Abraham <rabraham@kns.com>)
List pgsql-general
On 15 May 2017 at 19:25, Ronny Abraham <rabraham@kns.com> wrote:
>
> What’s interesting is that inserting to JSONB is slightly faster than inserting to JSON.
>
> Maybe that’s because my JSON has a flat structure (no nesting), or maybe I am doing something else wrong?

I assume it's because your json documents (10 fields) are not big enough. If you'll try the same tests
with something like 1000 keys for each document, there should be noticeable difference (at least in my
case it was like that).

pgsql-general by date:

Previous
From: Nick Dro
Date:
Subject: Re: [GENERAL] Coditional join of query using PostgreSQL
Next
From: Alban Hertroys
Date:
Subject: Re: [GENERAL] Coditional join of query using PostgreSQL