Benchmarking read performance of PostgreSQL and MongoDB on same data sets TL;DR: In first I’ve provided overview how was made decision to use certain database for one particular case (perhaps a way rare case). But after received messages and comments and feedbacks it feels like that case was considered as general. So I’ve improved and extended my benchmarks and I’m going to share updated information with you. article Not changed Data schema remains the same (2 entities: and with relationship ). storage file, 1 to many data example: postgres data example: mongo Changed Imported into databases entries as data and entries as data (was 500 and 4924**).** 2500 storage 24705 file Added more queries, in this benchmarking.Considered not only from previous benchmarking: query1 : query1 postgres : query1 mongo but also added bunch of else queries. Updated databases versions: → 10.5, 3.4.9 → 4.0.1. _PostgreSQL_ 10.0 MongoDB Added benchmarks which measure spent time for next steps: — connect into db, get data from db, print data. v1 — get data from db, print data (don’t measure connection time). v2 Benchmarking: All technical information about , , etc. you can find in . Docker PostgreSQL MongoDB github repo Result: For me, on my computer result looks like: +-------------+--------------------+--------------------+| Benchmark # | PostgreSQL 10.5    | MongoDB 4.0.1      |+-------------+--------------------+--------------------+| v1.query1   | 34137 microseconds | 52020 microseconds || v1.query2   | 20691 microseconds | 14950 microseconds || v1.query3   | 15952 microseconds | 14410 microseconds || v1.query4   | 18025 microseconds | 15389 microseconds |+-------------+--------------------+--------------------+| v2.query1   | 33596 microseconds | 43352 microseconds || v2.query2   | 20072 microseconds |  1711 microseconds || v2.query3   | 14750 microseconds |   573 microseconds || v2.query4   | 17727 microseconds |  1678 microseconds |+-------------+--------------------+--------------------+ I’ve omitted many benchmarks from this table because in simple queries just faster than . mongo postgres Conclusion: Only in my works faster than (because of ) for all other queries works a way faster than . query1 postgres mongo $unwind mongo postgres The question: which database is faster for your particular case?The answer: you have to benchmark!) PS: If you have interesting queries for benchmarking — please, let me know.

BUNCH

Too Long; Didn't Read

Making security fun one episode at a time

PostgreSQL vs MongoDB v2

Too Long; Didn't Read

Company Mentioned

V. K.

About Author

TOPICS

THIS ARTICLE WAS FEATURED IN...

PostgreSQL vs MongoDB v2

Too Long; Didn't Read

Company Mentioned

V. K.

About Author

TOPICS

THIS ARTICLE WAS FEATURED IN...

RELATED STORIES