Hi
I’m experiencing an issue with oban pro and the queue partitioning feature in particular.
I have setup the queue like this
The queue is the 3 one from the bottom in the second image. The only other queue with partitioning is the one at the bottom. All other queues just have local limits set up.
As the image shows the other queues aren’t doing anything.
I also have a bigger partition window configured config :oban_pro, Oban.Pro.Engines.Smart, partition_limit: 100_000
At first it looked like maybe the postgres cache wasn’t big enough to do these queries efficiently. But after giving postgres more ram, I still encoutered this problem.
Another thing I could observer where a lot of calls to pg_try_advisory_xact_lock in between queries to the oban_jobs table.
