On 4/30/07, John D. Burger <john(at)mitre(dot)org> wrote:
> 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?
They are fast, and can lock for sub-transaction durations, which is
sometimes useful when dealing with these types of problems.
merlin