Re:DigitalOcean S-1
by invisiblea on Thursday February 25, 2021 @10:11AM
(#26263528)
That's an entirely fair point, but frustrating that the connection limits are not clearer in the docs.
FWIW, if you’re using 75+ connections, it’s probably a good idea to add some kind of Postgres proxy in the middle like pgbouncer. Postgres doesn’t handle lots of connections well because each connection forks off its own full OS process, and the performance can degrade noticeably when you have too many connections to Postgres as a result.
That’s been my experience, at least.
This is the case for literally every managed database service that I'm aware of.
You pay a premium for the managed aspect.