GoodJob – a Postgres-based ActiveJob back end for Ruby on Rails

Re:GoodJob – a Postgres-based ActiveJob back end for Ruby on... by sideofbacon on Thursday July 23, 2020 @06:12PM (#23933091)

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

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.

[ Parent | on HN ]

Re:GoodJob – a Postgres-based ActiveJob back end for Ruby on... by Exuma on Thursday July 23, 2020 @09:02PM (#23934551)

The 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.

[ Parent | on HN ]

Re:GoodJob – a Postgres-based ActiveJob back end for Ruby on... by sideofbacon on Thursday July 23, 2020 @09:22PM (#23934688)

Thanks! That's really helpful context.

[ Parent | on HN ]