Rui-Jie Tay
Rui-Jie Tay
I have this question too!
Thanks @bensheldon! Looking forward to the day GoodJob uses `SKIP LOCKED` 🙂
Hey @rosa, we've actually increased our polling interval to 0.5 seconds as the default of 0.1s was consuming way too much CPU We're running Solid Queue on a separate Cloud...
We'd normally have around
Hey @rosa, I was also wondering if you guys are setting `preserve_finished_jobs` to false? I'm thinking if that might be causing some additional overhead to the database (on top of...
Hey @rosa, sorry for pinging again, but just checking to see if you have any inputs on this!
@rosa Thank you for the information! A few more questions, are the Solid Queue workers directly hitting the MySQL DB? Would you mind sharing the average number of connections your...
Hey thanks for the tips @jonatas! It looks like TRUNCATE requires an exclusive lock which might not be ideal since I'm pretty sure there are frequent read/writes to the `solid_queue_ready_executions`...
Hey @jonatas, would these values help if I'm already triggering a manual vacuum every few seconds or so? From what I've observed, I often see these "cancelling autovacuum task" errors,...
I see, thanks for the info @rosa! I was thinking to use wildcards together with the priority keywords so that I still can have separate queues for specific jobs while...