It's a great choice for higher budget applications too. At my job (public tech company, former startup), we use Postgres as our source of truth for just about everything that should go in an OLTP database (e.g. not analytics). I don't think there's another database product that would work as well for us as Postgres.