Postgres Pro
Downloads
Home   >   mailing lists

Re: Processing a work queue - Mailing list pgsql-general

From John D. Burger
Subject Re: Processing a work queue
Date
Msg-id 8DF4DA4A-3E86-42A7-B5D6-4DCC6DC57A81@mitre.org
Whole thread Raw
In response to Re: Processing a work queue  (Andrew - Supernews <andrew+nonews@supernews.com>)
Responses Re: Processing a work queue  ("Merlin Moncure" <mmoncure@gmail.com>)
Re: Processing a work queue  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Philippe Amelant
Date:
Subject: Server crash on postgresql 8.2.4 with tsearch2
Next
From: Oleg Bartunov
Date:
Subject: Re: Stemming not working with tsearch2() function