I think a lot of issues that people complain about PostgreSQL come from the fact that the default config is not very good if one wants to run it in production,

I think a lot of issues that people complain about PostgreSQL come from the fact that the default config is not very good if one wants to run it in production, even for relatively small workloads. Things like process per connection can kick one in the foot if one is not aware of how PG works.