3 ms·

A side note: MongoDB now dominates the famous framework benchmark in the read benchmarks. https://www.techempower.com/benchmarks/ https://www.techempower.com/b

A side note: MongoDB now dominates the famous framework benchmark in the read benchmarks. https://www.techempower.com/benchmarks/ https://www.techempower.com/benchmarks/

kuschku 9y ago
With 1.4% more performance than PostgreSQL, and far less guarantees w.r.t. schema. Yeah, that's not hard. It's surprising it took them this long. EDIT: The performance comparison that was linked, and that I was referring to: http://i.imgur.com/Thk5DlU.png http://i.imgur.com/Thk5DlU.png
- elvinyung 9y ago
  Edit: I'm dumb (and bad at reading words). I don't believe this assessment is entirely fair -- MongoDB essentially commits every write to a majority quorum of nodes. Remind me again how many machines a standard Postgres INSERT/UPDATE commits to? (Disclaimer: I still like Postgres better.)
  - kuschku 9y ago
    The benchmark measures almost exclusively read performance, so that's not really a question. Now the real question is why mongodb isn't faster than postgresql in this test. MongoDB gives so many guarantees up just to get more performance, and then looses to PostgreSQL? This is the worst trade deal in the history of trade deals.
    - elvinyung 9y ago
      Oh oops, totally misread "read" as "write" :P
- mrgordon 9y ago
  Yep exactly. People fall for these benchmarks too easily (especially the ones released by 10gen themselves)
- merb 9y ago
  well I wouldn't account that benchmark. Not for mongodb and especially not for PostgreSQL. TechEmpower Benchmarks are mostly not really showcasing real world. Just looking at their PostgreSQL config will highlight that. (Especially: https://github.com/TechEmpower/FrameworkBenchmarks/blob/master/toolset/setup/linux/databases/postgresql/postgresql.conf#L173 https://github.com/TechEmpower/FrameworkBenchmarks/blob/mast...) And also most of the time their libraries/frameworks are outdated or not even configured correctly. It shouldn't be taken as a reference in any way without additional benchmarking.
mrgordon 9y ago
Here is where I point out that MongoDB dominated write benchmarks when it first came out. And then everyone complained loudly that the benchmark was writing to PostgreSQL and flushing to disk while Mongo turned off safe writes so they'd do better on the benchmark. Once that was fixed, Mongo plummeted towards the bottom of the rankings. Best marketed database ever.

A side note: MongoDB now dominates the famous framework benchmark in the read benchmarks. https://www.techempower.com/benchmarks/ https://www.techempower.com/benchmarks/

kuschku 9y ago

With 1.4% more performance than PostgreSQL, and far less guarantees w.r.t. schema. Yeah, that's not hard. It's surprising it took them this long. EDIT: The performance comparison that was linked, and that I was referring to: http://i.imgur.com/Thk5DlU.png http://i.imgur.com/Thk5DlU.png

elvinyung 9y ago
Edit: I'm dumb (and bad at reading words). I don't believe this assessment is entirely fair -- MongoDB essentially commits every write to a majority quorum of nodes. Remind me again how many machines a standard Postgres INSERT/UPDATE commits to? (Disclaimer: I still like Postgres better.)
- kuschku 9y ago
  The benchmark measures almost exclusively read performance, so that's not really a question. Now the real question is why mongodb isn't faster than postgresql in this test. MongoDB gives so many guarantees up just to get more performance, and then looses to PostgreSQL? This is the worst trade deal in the history of trade deals.
  - elvinyung 9y ago
    Oh oops, totally misread "read" as "write" :P
mrgordon 9y ago
Yep exactly. People fall for these benchmarks too easily (especially the ones released by 10gen themselves)
merb 9y ago
well I wouldn't account that benchmark. Not for mongodb and especially not for PostgreSQL. TechEmpower Benchmarks are mostly not really showcasing real world. Just looking at their PostgreSQL config will highlight that. (Especially: https://github.com/TechEmpower/FrameworkBenchmarks/blob/master/toolset/setup/linux/databases/postgresql/postgresql.conf#L173 https://github.com/TechEmpower/FrameworkBenchmarks/blob/mast...) And also most of the time their libraries/frameworks are outdated or not even configured correctly. It shouldn't be taken as a reference in any way without additional benchmarking.

mrgordon 9y ago

Here is where I point out that MongoDB dominated write benchmarks when it first came out. And then everyone complained loudly that the benchmark was writing to PostgreSQL and flushing to disk while Mongo turned off safe writes so they'd do better on the benchmark. Once that was fixed, Mongo plummeted towards the bottom of the rankings. Best marketed database ever.