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
On Mon, May 15, 2017 at 12:02 PM, Ronny Abraham wrote:
> 4. Insert 10,000 rows to JSON, execution time (sec):
> 5. Insert 10,000 rows to JSONB, execution time (sec):
>
> What’s interesting is that inserting to JSONB is slightly faster than
> inserting to JSON.
With those times, only explanation i
each row), execution time (sec):
118.248999119
Thanks
Ronny
From: Dmitry Dolgov [mailto:9erthali...@gmail.com]
Sent: Monday, May 15, 2017 3:35 PM
To: Ronny Abraham
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Insert performance and disk usage in JSON vs JSONB
On 15 May 2017 at 19:25
On 15 May 2017 at 19:25, Ronny Abraham 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 fi
Here are the attachments.
From: Ronny Abraham
Sent: Monday, May 15, 2017 1:03 PM
To: 'pgsql-general@postgresql.org'
Subject: Insert performance and disk usage in JSON vs JSONB
Hello all,
I am trying to decide whether to use JSON or JSONB to store my application data.
From what I read so far ab
Hello all,
I am trying to decide whether to use JSON or JSONB to store my application data.
>From what I read so far about JSON vs JSONB:
Performance - JSON is faster for inserts since it only odes JSON format
verification, vs JSONB which