Re: Processing a work queue

From: "John D(dot) Burger" <john(at)mitre(dot)org>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Processing a work queue
Date: 2007-04-30 15:42:01
Message-ID: 8DF4DA4A-3E86-42A7-B5D6-4DCC6DC57A81@mitre.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andrew - Supernews wrote:

>> Anyone have any ideas on how to handle a work queue?
>
> Advisory locks (userlocks in pre-8.2).

Can someone explain why these are a better fit than whatever locks
SELECT FOR UPDATE acquires?

Thanks.

- John D. Burger
MITRE

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ted Byers 2007-04-30 15:48:26 Re: Temporal Units
Previous Message Tom Lane 2007-04-30 14:56:49 Re: Selecting from a function(x,y) returning a row-type(sum, prod)