News for hackers. Stuff that matters.

A comment on NoSQL Benchmark Compares PostgreSQL, MongoDB, Neo4j, OrientDB and ArangoDB. Parent comment

Re:NoSQL Benchmark Compares PostgreSQL, MongoDB, Neo4j, Orie... by andy_ppp on Tuesday October 13, 2015 @10:56AM (#10380861)
Just to be a pedant, the JSONB format as I understand is marginally slower at inserts and orders of magnitude faster at everything else...
[ Parent | on HN ]
Re:NoSQL Benchmark Compares PostgreSQL, MongoDB, Neo4j, Orie... by robconery on Tuesday October 13, 2015 @11:11AM (#10380983)
It's fractionally slower, true, because of the serialization hit (string to binary). The real juice comes from the GIN index - and if you apply it to specific columns instead of a complete document, you have a rocket ship on read.
[ Parent | on HN ]
Re:NoSQL Benchmark Compares PostgreSQL, MongoDB, Neo4j, Orie... by creshal on Tuesday October 13, 2015 @11:28AM (#10381090)
> It's fractionally slower, true, because of the serialization hit (string to binary).

And with JSON columns you have to serialize on accesses, which is a lot slower in the read-mostly tests.

[ Parent | on HN ]
Re:NoSQL Benchmark Compares PostgreSQL, MongoDB, Neo4j, Orie... by SilasX on Tuesday October 13, 2015 @01:40PM (#10382069)
Stupid question: isn't that the typical result of indexing? Slower writes for (much) faster lookups?
[ Parent | on HN ]