Benchmarking read performance of PostgreSQL and MongoDB on same data sets TL;DR: I am busy right now with writing new microservice for project and the target — is to create as fast microservice as possible. As programming language will be used (truly believe it’s super fast, and just perfect for such tasks). And in this article I will shed some light on reasons how was made decision to use certain database. web GOlang This topic isn’t new and you can find lot of benchmarks related to performance of these databases. But I didn’t manage to find any technical information about benchmarks (what, where, how, how much, what was used etc.) also no information about versions of databases (not every article which I’ve found provides this info) but maybe something has changed, maybe some DB works better now, and maybe my case is bit different from cases considered in other articles, so it’s my turn to benchmark these databases!) In my microservice I need to store 2 entities ( and ) with relationship (super simple case).It will be 2 tables in : storage file 1 to many postgres And in will have document with embedded data: mongo Nothing special so far, but the interesting thing — is that data will be received. Suppose we need to get information like this: how And to receive this exact information from both databases we have to run next SQL query in : postgres and this aggregation query in : mongo It’s unfair to benchmark join versus simple find, because already have all information (as nested data) but has to work… But with our query it’s gonna be more interesting!!!Each database have to perform almost same actions: to find data by non-indexed field , to order by and , perform and and must perform join when mongo must perform .I believe it’s pretty rightfully! postgres mongo mongo postgres count id name offset limit postgres unwind Benchmarking: All technical information about , , , , data-dumps, data import and so on and so forth you can find in .Please take a look, and check all steps or even perform this benchmark on your computer, or just review implementation for and . Docker PostgreSQL MongoDB GOlang github repo GOlang postgres mongo Result: For me, on my computer result looks like: +-------------+-------------------+--------------------+| Benchmark # | PostgreSQL | MongoDB |+-------------+-------------------+--------------------+| query 1 | 8349 microseconds | 21721 microseconds |+-------------+-------------------+--------------------+ Conclusion: It’s only my particular case, only my query, only read operation and my result on my computer… For your case you have to check your queries, your datasets, etc. If you find any gap or mistake or your result is different — please provide any feedback. If you have some another interesting test cases— please let me know! PS: I really like mongo and I’m looking how to speed it up — if you have any clue — please contact me!
