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

Re: SKIP LOCKED DATA

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: SKIP LOCKED DATA
Date: 2012-01-16 21:30:51
Message-ID: 4F14970B.1060902@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On 1/15/12 3:01 PM, Thomas Munro wrote:
> 5.  Probably many other things that I'm not aware of right now and
> won't discover until I dig/ask further and/or run into a brick wall!
> 
> Useful?  Doable?

Useful, yes.  Harder than it looks, probably.  I tried to mock up a
version of this years ago for a project where I needed it, and ran into
all kinds of race conditions.

Anyway, if it could be made to work, this is extremely useful for any
application which needs queueing behavior (with is a large plurality, if
not a majority, of applications).

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

In response to

Responses

pgsql-hackers by date

Next:From: Jeff JanesDate: 2012-01-16 21:37:59
Subject: Re: automating CF submissions (was xlog location arithmetic)
Previous:From: Josh BerkusDate: 2012-01-16 21:25:50
Subject: Re: automating CF submissions (was xlog location arithmetic)

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