Re:CouchDB vs. MongoDB
by coltonv on Thursday June 15, 2017 @11:27PM
(#14566447)
Mongo really isn't about storing JSON. At least that shouldn't be it's selling point. The selling point that is since it's basically just a glorified key value store it's very replicable and distributable. Postgres is very much not either of those things. The JSON is nice for a few things and I use it sometimes but Postgres is and will always be extremely difficult to cluster and replicate.
[ Parent
| on HN ]
Postgres 10 added support logical replication. It makes horizontal scaling fairly painless.
Re:CouchDB vs. MongoDB
by wutwutwutwut on Friday June 16, 2017 @01:28AM
(#14566867)
Until you need to reseed the original master, want to do quick rolling restarts or want any automation in automatic failover. PG has a long way to go.
A
Re:CouchDB vs. MongoDB
by manigandham on Saturday June 17, 2017 @07:39PM
(#14578213)
Logical replication by default doesn't even handle DDL statements so something as simple as adding a new column requires extra process. Postgres is probably the weakest of all relational databases when it comes to scalability, both vertical and horizontal.