Postgres queue technology may not be well-known or widely used due to the obsession with scalability. Many believe that there are better queue technologies available, but some companies, like webapp.io, recognize that other factors outweigh scalability. Postgres queue tech consists of pub/sub and row locking features that make it easy to add queue functionality to applications. Despite its capabilities, there are few advocates for using Postgres as a queue backend. Redis is often the default choice for background jobs due to its scalability, but it’s important to consider other factors such as familiarity and maintenance burden. Choosing boring technology and building with escape hatches can lead to better technology decisions.
https://adriano.fyi/posts/2023-09-24-choose-postgres-queue-technology/