4 ms·
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
by coltonv 9y ago
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.
- sgk284 9y agoPostgres 10 added support logical replication. It makes horizontal scaling fairly painless.
- wutwutwutwut 9y agoUntil 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
- manigandham 9y agoLogical 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.