If pgbouncer makes this big a difference to performance, is it included in managed PostgreSQL services, such as Amazon RDS and Heroku Postgres?
Or would you have to roll your own pgbouncer setup for these systems?
Or would you have to roll your own pgbouncer setup for these systems?
https://postgres.heroku.com/blog/past/2013/11/22/connection_... https://github.com/gregburek/heroku-buildpack-pgbouncer
Has anyone used this? Is it configurable, or do they just choose some reasonable defaults?
In my python app, I switched from an sqlalchemy connection pool per process (eg per gunicorn worker) to using a Null pool everwhere. No increase in latency; far fewer connections needed.