Does MongoDB support ACID transactions? What are the limits?

Answer preview

Yes. MongoDB has always been ACID for a single document; since 4.0 it supports multi-document ACID transactions on replica sets, and since 4.2 across shards in a sharded cluster. The caveat is that they are slower and more constrained than in PostgreSQL, so they are the exception…