The honest question is never "which database is better". It is what shape your data has, how you will read it, and which writes must never be wrong. Start with Postgres, and learn what would make you leave.
This deep-dive architectural analysis is part of the System Design & 75 Labs pass.