From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Dimitri Fontaine <dimitri(at)2ndquadrant(dot)fr> |
Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: elegant and effective way for running jobs inside a database |
Date: | 2012-03-06 22:01:24 |
Message-ID: | 1331071100-sup-4771@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Excerpts from Dimitri Fontaine's message of mar mar 06 18:44:18 -0300 2012:
> Josh Berkus <josh(at)agliodbs(dot)com> writes:
> > Activity and discretion beyond that could be defined in PL code,
> > including run/don't run conditions, activities, and dependancies. The
> > only thing Postgres doesn't currently have is a clock which fires
> > events. Anything we try to implement which is more complex than the
> > above is going to not work for someone. And the pg_agent could be
> > adapted easily to use the Postgres clock instead of cron.
>
> Oh, you mean like a ticker? If only we knew about a project that did
> implement a ticker, in C, using the PostgreSQL licence, and who's using
> it in large scale production. While at it, if such a ticker could be
> used to implement job queues…
>
> https://github.com/markokr/skytools/tree/master/sql/ticker
Why do we need a ticker? Just fetch the time of the task closest in the
future, and sleep till that time or a notify arrives (meaning schedule
change).
--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2012-03-06 22:07:51 | Re: elegant and effective way for running jobs inside a database |
Previous Message | Merlin Moncure | 2012-03-06 21:56:19 | Re: elegant and effective way for running jobs inside a database |