Re: SKIP LOCKED DATA

Thomas Munro <munro@ip9.org> writes:
> A common usage for this is to increase parallelism in systems with
> multiple workers taking jobs from a queue.  I've used it for this
> purpose myself on another RDBMS, having seen it recommended for some
> types of work queue implementation.  It may have other uses.

To attack this problem in PostgreSQL we also have PGQ, which is
Skytools3 has support for cooperative consumers.

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support