We run a similar setup at Kloudless [1]. We use PgBouncer [2] for connection poo...

vinodc on Aug 31, 2014 | parent | context | favorite | on: Replicated PostgreSQL with pgpool2

We run a similar setup at Kloudless [1]. We use PgBouncer [2] for connection pooling, which connects to pgpool2 to load balance between our Postgres servers. We've noticed PgBouncer is more performant at handling thousands of simultaneous connections.

[1] https://kloudless.com [2] http://wiki.postgresql.org/wiki/PgBouncer

techdragon on Sept 1, 2014 [–]

pgbouncer is like having an nginx reverse proxy in front of your postgres connections.