Disclaimer; my personal approach to building a new system defaults to "just use Postgres".

That said, this post is good to read if you want to understand why some people feel that Postgres culture is /deeply/ flawed.