Re: [HACKERS] proposal: contrib module - generic command scheduler

2015-08-20 Thread Pavel Stehule
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

Re: [HACKERS] proposal: contrib module - generic command scheduler

2015-08-20 Thread Alvaro Herrera
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

Re: [HACKERS] proposal: contrib module - generic command scheduler

2015-05-14 Thread Jim Nasby
On 5/14/15 1:36 AM, Pavel Stehule wrote: I don't think we want to log statements, but we should be able to log when a job has run and whether it succeeded or not. (log in a table, not just a logfile). This isn't something that can be done at higher layers either; only the

Re: [HACKERS] proposal: contrib module - generic command scheduler

2015-05-14 Thread Pavel Stehule
2015-05-14 19:12 GMT+02:00 Jim Nasby jim.na...@bluetreble.com: On 5/14/15 1:36 AM, Pavel Stehule wrote: I don't think we want to log statements, but we should be able to log when a job has run and whether it succeeded or not. (log in a table, not just a logfile). This isn't

Re: [HACKERS] proposal: contrib module - generic command scheduler

2015-05-14 Thread Pavel Stehule
2015-05-14 8:01 GMT+02:00 Jim Nasby jim.na...@bluetreble.com: On 5/13/15 1:32 AM, Pavel Stehule wrote: 5. When command waits to free worker, write to log 6. When command was not be executed due missing workers (and max_workers 0), write to log Also

Re: [HACKERS] proposal: contrib module - generic command scheduler

2015-05-14 Thread Jim Nasby
On 5/13/15 1:32 AM, Pavel Stehule wrote: 5. When command waits to free worker, write to log 6. When command was not be executed due missing workers (and max_workers 0), write to log Also unfortunate. We already don't provide enough monitoring

Re: [HACKERS] proposal: contrib module - generic command scheduler

2015-05-13 Thread Pavel Stehule
2015-05-13 7:50 GMT+02:00 Jim Nasby jim.na...@bluetreble.com: On 5/12/15 11:32 PM, Pavel Stehule wrote: I would not to store state on this level - so at should be implemented on higher level. There is very high number of possible strategies, what can be done with

Re: [HACKERS] proposal: contrib module - generic command scheduler

2015-05-12 Thread Dave Page
On Tue, May 12, 2015 at 10:25 AM, Pavel Stehule pavel.steh...@gmail.com wrote: Generic simple scheduler to contrib === Job schedulers are important and sometimes very complex part of any software. PostgreSQL miss it. I propose new contrib module, that can be

[HACKERS] proposal: contrib module - generic command scheduler

2015-05-12 Thread Pavel Stehule
Generic simple scheduler to contrib === 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

Re: [HACKERS] proposal: contrib module - generic command scheduler

2015-05-12 Thread Pavel Stehule
2015-05-12 11:27 GMT+02:00 hubert depesz lubaczewski dep...@depesz.com: On Tue, May 12, 2015 at 09:25:50AM +0200, Pavel Stehule wrote: create type scheduled_time as (second int[], minute int[], hour int[], dow int[], month int[]); (,{1,10,20,30,40,50},,,) .. run every 10 minutes.

Re: [HACKERS] proposal: contrib module - generic command scheduler

2015-05-12 Thread Craig Ringer
On 13 May 2015 at 00:31, Pavel Stehule pavel.steh...@gmail.com wrote: 2015-05-12 11:27 GMT+02:00 hubert depesz lubaczewski dep...@depesz.com: On Tue, May 12, 2015 at 09:25:50AM +0200, Pavel Stehule wrote: create type scheduled_time as (second int[], minute int[], hour int[], dow int[],

Re: [HACKERS] proposal: contrib module - generic command scheduler

2015-05-12 Thread Pavel Stehule
2015-05-12 10:45 GMT+02:00 Dave Page dp...@pgadmin.org: On Tue, May 12, 2015 at 10:25 AM, Pavel Stehule pavel.steh...@gmail.com wrote: Generic simple scheduler to contrib === Job schedulers are important and sometimes very complex part of any software.

Re: [HACKERS] proposal: contrib module - generic command scheduler

2015-05-12 Thread Jim Nasby
On 5/12/15 11:32 PM, Pavel Stehule wrote: I would not to store state on this level - so at should be implemented on higher level. There is very high number of possible strategies, what can be done with failed tasks - and I would not to open this topic. I believe

Re: [HACKERS] proposal: contrib module - generic command scheduler

2015-05-12 Thread Pavel Stehule
2015-05-13 4:08 GMT+02:00 Craig Ringer cr...@2ndquadrant.com: On 13 May 2015 at 00:31, Pavel Stehule pavel.steh...@gmail.com wrote: 2015-05-12 11:27 GMT+02:00 hubert depesz lubaczewski dep...@depesz.com: On Tue, May 12, 2015 at 09:25:50AM +0200, Pavel Stehule wrote: create type