Better way to handle db connections in SaaS

[sattvikc]

🚀 Enhancement

We now allocate max_connections based on max connections on the database divide over number of apps using that db. However, this is not very efficient because all apps don't have same needs. Some need more, some need less. So we need to come up with a dynamic solution that manages connections efficiently across all the apps.

Implementation details

TODO

[rishabhpoddar]

Also consider checking out pgbouncer.