On 15 May 2017 at 19:25, Ronny Abraham <rabraham@xxxxxxx> 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).
>
> 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).
