| From: | "Alexander Staubo" <alex(at)purefiction(dot)net> |
|---|---|
| To: | "Steve Crawford" <scrawford(at)pinpointresearch(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Processing a work queue |
| Date: | 2007-04-26 23:18:38 |
| Message-ID: | 88daf38c0704261618s91256c3tb01254871578a143@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 4/27/07, Steve Crawford <scrawford(at)pinpointresearch(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-04-26 23:51:48 | Re: NFS vs. PostgreSQL on Solaris |
| Previous Message | Steve Crawford | 2007-04-26 22:36:35 | Processing a work queue |