Database Pool Management with Sidekiq and load_async

Recently I came across a very common issue after integrating a few Sidekiq jobs to a project.

During this activity, I set the pool size in database.yml of the worker process equal to the concurrency I set for Sidekiq. Its recommended to have pool size equal to or greater than the concurrency setting otherwise, you can run into issues or even if there are no apparent errors, this will likely cause additional latency in the queues.

But strangely, I still …

backenddevelopment concurrency database issue jobs management pool process project rails set