oban v0.10.0 Release Notes
Release Date: 2019-10-03 // over 4 years ago-
Migration Optional (V5)
Tables with a lot of available jobs (hundreds of thousands to several million) ⚡️ are prone to time outs when fetching new jobs. The planner fails to optimize ⏱ using the index available on
queue
,state
andscheduled_at
, forcing both a slow sort pass and an expensive bitmap heap scan.This migration drops the separate indexes in favor of a a single composite index. The resulting query is up to 258,757x faster on large tables while 🚧 still usable for all of the other maintenance queries.
⚡️ History of the
EXPLAIN ANALYZE
output as the query was optimized is available here: https://explain.depesz.com/s/9Vh7🔄 Changed
- 0️⃣ [Oban.Config] Change the default for
verbose
fromtrue
tofalse
. Also,:verbose
now accepts onlyfalse
and standard logger levels. This change aims to prevent crashes due to conflicting levels when the repo's log level is set tofalse
.
🛠 Fixed
- [Oban.Notifier] Restructure the notifier in order to to isolate producers from connection failures. Errors or loss of connectivity in the notification connection no longer kills the notifier and has no effect on the producers.
- 0️⃣ [Oban.Config] Change the default for