Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group