Hacker News new | ask | show | jobs
by invisiblea 1943 days ago
That's an entirely fair point, but frustrating that the connection limits are not clearer in the docs.
1 comments

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.

And DO's hosted Postgres allows you to easily configure pgbouncer.