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
How PostgreSQL uses SKIP LOCKED and UNLOGGED tables to reduce queue contention, WAL volume, and operational overhead.