6 months ago
I thought there is no limit on the db connections but I hit an error saying that the limit was reached. I had min_connections = 10 and added 5 workers per instances and launched 5 instances and it wasn't working at all, got the error that limit was reached.
I lowered the number of min_connections as I don't actually need 10, but anybody can explain what happened? I was under the impression there is no limit on the db connections.
2 Replies
6 months ago
Hello,
Our infrastructure does not impose database connection limits, but the databases themselves have self imposed connection limits, for example, MySQL has a connection limit of 151, and Postgres has a connection limit of 100.
6 months ago
I have Postgres on Render and it has a limit of 100 connections if the DB is under 8GB RAM but I can upgrade to 8GB RAM DB and have 200 connections...I can go up to 500 connections for over 32GB RAM so it feels like it's not a limitation on Postgres...
But I get it, maximum 100 connections. So I have to put pgbouncer back :)