On 4/27/07, Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx> wrote:
Anyone have any ideas on how to handle a work queue? I've been thinking about optimizing this process for quite a while.
I have been using PostgreSQL for the exact same thing, except I have not yet reached the stage where I need to process queue items in parallel. :) Anyway, this question has been covered several times, and I believe this post by Tom Lane delineates the canonical recipe: http://archives.postgresql.org/pgsql-general/2003-05/msg00351.php Alexander.
