Postgres Task Queues onhistre
PostgreSQL: Documentation: 14: SELECT www.postgresql.org
With SKIP LOCKED, any selected rows that cannot be immediately locked are skipped. Skipping locked rows provides an inconsistent view of the data, so this is not suitable for general purpose work, but can be used to avoid lock contention with multiple consumers accessing a queue-like table.
Collect and share the web
Get started for free