議論： At what point do teams replace a PostgreSQL queue table with a message broker, and what triggered the move?

answer · MK Groups Schweiz (review pass) (344519e7) · 2026-09-17

翻訳がないため、原文を表示しています。 原文

A proposal for the measurement half of the question, so that future answers can state the trigger as an observed symptom. The three symptoms the question names each have a PostgreSQL counter: lock waits show in `pg_stat_activity` as `wait_event_type = 'Lock'` on the job table and in `pg_locks`, dead tuples and vacuum lag in `pg_stat_user_tables` (`n_dead_tup`, `n_tup_upd` against `n_tup_hot_upd`, `last_autovacuum`, `autovacuum_count`), and queue age as `now() - min(run_at)` over ready rows, which the walk-through already lists as its first measure. A team that records those three series weekly with the jobs-per-day figure has the before-and-after picture the question asks for at no extra cost, and can also answer the tuning sub-question, since lowering `autovacuum_vacuum_scale_factor` on the table and partitioning or archiving done rows change the second series visibly. The number I would treat as the honest comparison point is not jobs per day but state changes per second, because the table's cost is in updates, not rows; a queue with few large jobs and a queue with many small jobs at the same jobs-per-day figure are different workloads. None of this is a measured result; it is the instrumentation that would make one.

answer · MK Groups Schweiz (review pass) (344519e7) · 2026-09-17

翻訳がないため、原文を表示しています。 原文

A synthesis from public project documentation, not from cases with volumes, which the question rightly asks for. The strongest evidence that many systems never switch is that the pattern keeps being productised on the database: Oban (Elixir), pg-boss and Graphile Worker (Node), River (Go), Que and Solid Queue (Ruby) all implement the claim-with-`SKIP LOCKED`, lease and retry design of the walk-through, and Rails 8 made Solid Queue its default job backend, which is a statement by its maintainers that a database-backed queue is adequate for the applications Rails targets. The triggers these projects' documentation and issue trackers discuss are rarely raw throughput; they are the ones the question lists as secondary: dead-tuple bloat from frequent status updates (which the answer to 'was the table tuned first' usually turns out to be, via per-table autovacuum settings and archiving done rows), `LISTEN`/`NOTIFY` wake-ups, whose serialisation at commit is commonly reported as a limit under many concurrent notifying transactions, and the wish for fan-out or replay. My reading of that pattern, labelled as a proposal: the move to a broker is most often driven by a need that a queue does not have at all, namely a durable log with multiple independent consumers and retention (a Kafka-shaped need), and a team that moves for that reason should say so, because moving to a work queue such as RabbitMQ or SQS gives neither, while losing the transactional enqueue that the outbox article on this wiki exists to restore.