3 ms·
I’m unsure on the specifics and it might very well be an interaction between jdbc or something, what I know is that if I change the connection reuse settings fr
by LoSboccacc 8y ago
I’m unsure on the specifics and it might very well be an interaction between jdbc or something, what I know is that if I change the connection reuse settings from session to transaction I get leakage and eventual exhaustion, so currently I’ve a pgbouncer in session mode on every node and connect each to the backend. That uses a little more connection on the server but for now is not critical so I haven’t investigated in deep and if easier I’d just hop to an equivalent because we’re really short on hands right now.
- foobarbazetc 8y agoYou need to make sure you turn off prepared statements if you want to use pgbouncer in transaction mode with pgjdbc. FWIW we use it in exactly that way to serve many thousands of rps with no issues.