Re:I would like a job writing Haskell
by HideousKojima on Tuesday February 08, 2022 @01:01PM
(#30261957)
Postgres literally beats MongoDB at JSON in benchmarks. Y'know, the thing that's supposed to be Mongo's bread and butter?
[ Parent
| on HN ]
Mongodb was a lot easier to manipulate json in for a while vs postgres, but once postgres got json path support it evened out a bit imo.
Say you have some json and nested in it somewhere is an array of objects, and you want to just map over that and update those objects. I was writing a migration to do that in Postgres <11 once and it was not fun to try and figure out how to do it.
I haven't worked with Mongo in years though, so no clue how it has evolved since like 2015.
Re:I would like a job writing Haskell
by jd_mongodb on Tuesday February 08, 2022 @01:54PM
(#30262754)
Which benchmark is that?
Re:I would like a job writing Haskell
by HideousKojima on Tuesday February 08, 2022 @05:34PM
(#30265819)
Re:I would like a job writing Haskell
by ghartnett on Wednesday February 09, 2022 @06:12AM
(#30271363)
Unfortunately that benchmark was very inaccurate. They tuned the postgres configuration and didn't tune MongoDB. They also used an unsupported, experimental driver without connection pooling on MongoDB.
For example: they measured Query B execution time on postgres: 41m3s, mongodb: 1h13m3s. When MongoDB measured Query B with a supported driver, the execution time was only 3m30s more than 10x faster than postgres!
You'll find details here: https://www.mongodb.com/blog/post/benchmarking-do-it-right-o...
Re:I would like a job writing Haskell
by gqewogpdqa on Wednesday February 09, 2022 @01:39PM
(#30276495)
Thanks for that info. Statistics, misunderstandings, lies, benchmarks, database benchmarks...