2 ms·
The way that Oban for Elixir and GoodJob for Ruby leverage PostgreSQL allows for very high throughput. It's not something that easily ports to other DBs.
by brightball 9mo ago
The way that Oban for Elixir and GoodJob for Ruby leverage PostgreSQL allows for very high throughput. It's not something that easily ports to other DBs.
- owaislone 9mo agoInteresting. Any docs that explain what/how they do this?
- brightball 9mo agoGood Job is a strong attempt. I believe it's based around Advisory Locks though. https://github.com/bensheldon/good_job https://github.com/bensheldon/good_job
- TkTech 9mo agoA combination of LISTEN/NOTIFY for instantaneous reactivity, letting you get away with just periodic polling, and FOR UPDATE...SKIP LOCKED making it efficient and safe for parallel workers to grab tasks without co-ordination. It's actually covered in the article near the bottom there.
- owaislone 9mo agoThank you
- BowBun 9mo agoAppreciate the added context here, this is indeed some special sauce that challenges my prior assumptions!