2 ms·
GoodJob author here. Excellent observation. It should work if PgBouncer is using session-level pooling, but not transaction-level pooling. I made a ticket to d
by sideofbacon 6y ago
GoodJob author here. Excellent observation.
It should work if PgBouncer is using session-level pooling, but not transaction-level pooling. I made a ticket to document this: https://github.com/bensheldon/good_job/issues/52 https://github.com/bensheldon/good_job/issues/52
I don't have much experience with PgBouncer. What's the scale/need when a team would use PgBouncer? That would help me prioritize supporting it better.
- Exuma 6y agoThe main reason I can think of would be when you have hundreds of workers accessing a DB but the DB only has a small connection limit, say 200 or something. You can have the workers access the connection through pgBouncer to bring that up into the thousands.
- sideofbacon 6y agoThanks! That's really helpful context.