Re: SKIP LOCKED DATA - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: SKIP LOCKED DATA
Date
Msg-id m2sjjfv0o9.fsf@2ndQuadrant.fr
Whole thread Raw
In response to SKIP LOCKED DATA  (Thomas Munro <munro@ip9.org>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: pg_stat_database deadlock counter
Next
From: Magnus Hagander
Date:
Subject: Warning in views.c