Re: proposal: contrib module - generic command scheduler - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: proposal: contrib module - generic command scheduler
Date
Msg-id CAFj8pRDoF=_oA4mjeRoMjGbez8Se01MVPy7FH9w2eLaOB_a6Dg@mail.gmail.com
Whole thread Raw
In response to Re: proposal: contrib module - generic command scheduler  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Hi

2015-08-20 16:42 GMT+02:00 Alvaro Herrera <alvherre@2ndquadrant.com>:
Pavel Stehule wrote:

Hi,

> Job schedulers are important and sometimes very complex part of any
> software. PostgreSQL miss it. I propose new contrib module, that can be
> used simply for some tasks, and that can be used as base for other more
> richer schedulers. I prefer minimalist design - but strong enough for
> enhancing when it is necessary. Some complex logic can be implemented in PL
> better than in C. Motto: Simply to learn, simply to use, simply to
> customize.

Have you made any progress on this?

I am working on second iteration prototype - resp. I worked one month ago. I finished the basic design, basic infrastructure. I designed architecture based on one coordinator and dynamicaly started workers.

I found, so probably some fair policy should be implemented in future.

I have to finish other requests now, so I am planning to continue at end of autumn, but sources are public

https://github.com/okbob/generic-scheduler, Not sure, about code quality - I had not time to debug it. But mental model (UI) is almost complete - https://github.com/okbob/generic-scheduler/blob/master/schedulerx--1.0.sql

I found as interesting idea to handle not only time events, but handle our notifications too. It can be perfect base for building some complex workflow systems. But I did zero work on this topic.

Regards

Pavel



 
 

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 9.5 release notes
Next
From: Pavel Stehule
Date:
Subject: Re: proposal: function parse_ident