Postgres Job Queue Email: Reliable Sends with SKIP LOCKED
Build a postgres job queue for transactional email: enqueue in the business transaction, claim with SKIP LOCKED, retry safely, and handle duplicates.
14 min read
Tag
Build a postgres job queue for transactional email: enqueue in the business transaction, claim with SKIP LOCKED, retry safely, and handle duplicates.
14 min read
Build a Postgres SKIP LOCKED job queue for a monolith: schema, claim query, leases, retries, LISTEN/NOTIFY, cleanup, monitoring, and when to use a broker.
14 min read
How SKIP LOCKED Postgres queues and Redis queues work, where each fails, and measurable signals for choosing, sizing and migrating between them.
14 min read