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