insert into jobs (queue, idem_key, payload)values ($1, $2, $3)on conflict (queue, idem_key) do nothing;Exactly-once is a lie: an idempotent job queue on Postgres
We replaced a broker with one table, a unique index and SKIP LOCKED. What we gave up, what we got back, and the numbers after six months.
Deniz Aksoy @deniz