On Thu, Jul 18, 2013 at 2:31 PM, Thomas Kellerer <spam_eater@gmx.net> wrote:
Joe Van Dyk wrote on 18.07.2013 23:23:
Will the custom worker support in 9.3 let me put cron-like tasks into postgresql?
I have a lot of database functions that should run every few seconds, every minute, every hour, once a week, etc. Right now, I always have to have exactly one machine setup with cron tasks that tells postgresql to run whatever functions are necessary.
It would be super to let postgresql handle all of that.
That falls into the category of having to run another singleton (exactly one instance running) bit of software at all times. Not much difference between pgagent and cron, as far as I can tell.
I already always have a single postgresql master running at all times, it would be awesome the postgresql master process could be used to fire off these scheduled tasks. It seems like that would simplify many systems.