On 4/30/07, John D. Burger <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
