Re:How to Manage Connections Efficiently in Postgres, or Any...
by EB66 on Tuesday October 16, 2018 @01:03AM
(#18226674)
> PgBouncer doesn’t save you from a lot of the actual pain when dealing with connections. And that’s prepared statements, you can’t pool prepared statements
Prepared statements work fine with PgBouncer when you have session pooling enabled (as opposed to transaction pooling).
It may not save you from all the pain of dealing with connections, but PgBouncer definitely helps a lot when you're working with remote Postgres servers and high latency (i.e., > 10ms). Mitigating the delay and cost of connection initiation is pretty huge.
Prepared statements work fine with PgBouncer when you have session pooling enabled (as opposed to transaction pooling).
It may not save you from all the pain of dealing with connections, but PgBouncer definitely helps a lot when you're working with remote Postgres servers and high latency (i.e., > 10ms). Mitigating the delay and cost of connection initiation is pretty huge.