Ronny Abraham schrieb am 15.05.2017 um 19:25:
> 4. Insert 10,000 rows to JSON, execution time (sec):
>
> 122.855001211
>
> 5. Insert 10,000 rows to JSONB, execution time (sec):
>
> 122.128999233
>
>
> What’s interesting is that inserting to JSONB is slightly faster than inserting to JSON.
A difference in 0.7 seconds from a single test run is not significant enough to warrant the statement "JSONB is slightly faster".
That could very well have been caused by other things going on your system.
Or maybe just some caching of metadata.
Unless you repeat this at least 4 or 5 times, you can't tell if one is really faster then the other.