Re:Goodbye MongoDB, Hello PostgreSQL (2015)
by YouthfulMarxism on Thursday March 11, 2021 @02:49AM
(#26421426)
A single point for Mongo over Postgre JsonB is WiredTiger is very good at compression. In times of Mongo:4.0 vs Postgre:10.5 it was like 20Gb vs 50Gb. Though could depend on documents structure. Not sure about current state.
Querries were also somewhat faster in Mongo.
[ Parent
| on HN ]
Re:Goodbye MongoDB, Hello PostgreSQL (2015)
by Doxin on Thursday March 11, 2021 @03:55AM
(#26421820)
> A single point for Mongo over Postgre JsonB is WiredTiger is very good at compression
Granted, the compression story in postgres isn't currently amazing.
> Querries were also somewhat faster in Mongo.
If you really want fast queries it's not super hard to tune postgres to be fast and drop data if it crashes. It's a bit trickier to tune it to be quite that fast if you want to keep all your data, but for a single table of json documents it should be doable if you're okay with not having transactions.