On 03/06/2012 06:12 PM, Christopher Browne wrote:
On Tue, Mar 6, 2012 at 5:01 PM, Alvaro Herrera
<alvhe...@commandprompt.com> wrote:
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).
Keep in mind that cron functionality also includes "batch", which
means that the process needs to have the ability to be woken up by the
need to handle some pressing engagement that comes in suddenly.
For some events to be initiated by a NOTIFY received by a LISTENing
batch processor would be pretty slick...
We don't slavishly need to reproduce every piece of cron. In any case,
on my Linux machine at least, batch is part of the "at" package, not the
"cron" package. If you want anything at all done, then I'd suggest
starting with a simple scheduler. Just about he quickest way to get
something rejected in Postgres is to start with something overly complex
and baroque.
cheers
andrew
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
