As a pretty basic user, it is mostly about adaptation costs regarding tooling, infra and code. My current stack mostly includes mysql as the default db, so my applications and tools also default to mysql and for now I don't see a huge benefit since all I mainly do is CRUD. I am considering pgsql for some new stuff, but for the existing applications I don't see any benefit to move to postgre for now.