Hi 2015-08-20 16:42 GMT+02:00 Alvaro Herrera <alvhe...@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 >
