4 ms·
Postgres does all that plus 100x.
by cpursley 3y ago
Postgres does all that plus 100x.
- winrid 3y agoBut the horizontal scaling is easier with Mongo than Citus.
- yawaramin 3y agoBut you don't need to horizontally scale if you use a beefy Postgres instance. Horizontal scaling is a problem created by using an inefficient DB in the first place.
- winrid 3y agoI have DB clusters with masters with a terrabyte of ram. Going beyond that is a PITA with warming up cache, backups, and so on. There is a reason there's a huge industry for shared databases. Also, query for query, Mongo isn't going to be that much slower than PG, and faster for some usage patterns...
- winrid 3y ago*sharded
- tgv 3y agoI've also tried SQLite, but they didn't do large documents that well. And the project was started before I was aware Postgresql had json support. But what's the advantage of Postgresql in this case?