Re: SKIP LOCKED DATA

From: Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
To: Thomas Munro <munro(at)ip9(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: SKIP LOCKED DATA
Date: 2012-01-16 20:43:02
Message-ID: m2sjjfv0o9.fsf@2ndQuadrant.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thomas Munro <munro(at)ip9(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2012-01-16 20:47:49 Warning in views.c
Previous Message Magnus Hagander 2012-01-16 20:19:27 pg_stat_database deadlock counter