tags
SQL
2 posts tagged here.
DO NOT USE LISTEN/NOTIFY for a PostgreSQL Queue
Consumers of a Postgres Queue can either choose LISTEN/NOTIFY or poll for new items. This post recommends polling for PostgreSQL queues.
Why your next queue should use PostgreSQL
Postgres features like FOR UPDATE SKIP LOCKED and UNLOGGED tables make it a strong candidate for queueing. This post explains why and sets up detailed benchmarks.