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

From Alexander Staubo
Subject Re: Processing a work queue
Date
Msg-id 88daf38c0704261618s91256c3tb01254871578a143@mail.gmail.com
Whole thread Raw
In response to Processing a work queue  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-general
On 4/27/07, Steve Crawford <scrawford@pinpointresearch.com> 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.

pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Processing a work queue
Next
From: Tom Lane
Date:
Subject: Re: NFS vs. PostgreSQL on Solaris