Re: proposal: contrib module - generic command scheduler
| От | Pavel Stehule |
|---|---|
| Тема | Re: proposal: contrib module - generic command scheduler |
| Дата | |
| Msg-id | CAFj8pRDoF=_oA4mjeRoMjGbez8Se01MVPy7FH9w2eLaOB_a6Dg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: proposal: contrib module - generic command scheduler (Alvaro Herrera <alvherre@2ndquadrant.com>) |
| Список | 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
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 по дате отправления: