5 ms·
Would this work with pgbouncer? I'm wondering because of the advisory locks.
by SkyLinx 6y ago
Would this work with pgbouncer? I'm wondering because of the advisory locks.
- sideofbacon 6y agoGoodJob 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.