On 4/30/07, John D. Burger <john@xxxxxxxxx> 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
