4 ms·
I would really love to see a direct comparison for scaling MongoDB and PostgreSQL. When do I usually need to scale up / out in either database? How do I assess
by verst 7y ago
I would really love to see a direct comparison for scaling MongoDB and PostgreSQL.
When do I usually need to scale up / out in either database? How do I assess that? And how do I actually go about scaling?
Specifically I would love to know how to scale up and scale out (what are the different multi-node options and what are the consistency / replication delay guarantees)?
The last time I used Mongo in production (2013) most startups eventually had to switch databases or hire a consultant to scale. This has always stuck with me.
- gshulegaard 7y agoI have spent most of my (limited) career scaling PostgreSQL with (IMO) surprisingly good results. Most recently I have been using Citus and it has been ridiculously easy to shard data. To be fair I have only been exposed to workloads of a few Terabytes of data ingest a day so YMMV. Unfortunately, I can't compare to Mongo as I have had somewhat limited experience with it.
- matchy 7y ago> can’t compare to Mongo as I have had somewhat limited experience with it Doesn’t seem to stop most people here.