Re:Comparison of Joins: MongoDB vs. PostgreSQL
by gshulegaard on Friday April 10, 2020 @02:19PM
(#22835824)
I 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.
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.