Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL as advanced job queuing system - Mailing list pgsql-general

From Dominique Devienne
Subject Re: PostgreSQL as advanced job queuing system
Date
Msg-id CAFCRh-9+yJQmR52ttA6+h+yrBmM5Q_X1k0q_f8fNDcr5obusZg@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL as advanced job queuing system  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: PostgreSQL as advanced job queuing system  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Tree view
On Sat, Mar 23, 2024 at 3:13 AM Merlin Moncure <mmoncure@gmail.com> wrote:
On Fri, Mar 22, 2024 at 6:58 AM ushi <ushi@mailbox.org> wrote:
the idea to implement a job queuing system using PostgreSQL.

I wrote an enterprise scheduler, called pgtask, which ochestates a very large amount of work [...]

Hi. Anything you can share? OSS? Doesn't look like it...
If it's not, a more details higher level architecture overview would be nice.
 
I'm running at a pretty high scale and it's reliable. [...]

Sounds great.
 
Being able to manage the state explicitly in the database is wonderful, if you know what you're doing.

Indeed. I want to reduce the complexity of the stack as much as possible, and rely only on PostgreSQL, if possible.
We don't need a super duper queue or full distributed system. So a PostgreSQL-based solution aught to be enough. --DD

pgsql-general by date:

Previous
From: Thiemo Kellner
Date:
Subject: Re: Empty materialized view
Next
From: Thiemo Kellner
Date:
Subject: Re: Is this a buggy behavior?