Comment on NoSQL Benchmark Compares PostgreSQL, MongoDB, Neo4j, OrientDB and ArangoDBparentComments−robconery10yIt'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.−creshal10yIt'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.
Comments
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.
And with JSON columns you have to serialize on accesses, which is a lot slower in the read-mostly tests.