Comment by shahinghasemi

As you mentioned there are easy workaround for this issue on both application and infrastructure level: implementing rate limiters, monitoring/alerting systems for DB resource usages, putting quotas for tenants, etc. After all a postgreSQL instance in 16GB ram and 8core cpu can handle pretty much of the traffic for most SaaS products at their first stage.