4 ms·
> 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 Pr
by EB66 8y ago
> 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.
- dijit 8y agoOnly if your code is not connection pooling itself. In my case that is true, but for a php webapp (for example) it is a lot less true.