Re: elegant and effective way for running jobs inside a database - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: elegant and effective way for running jobs inside a database
Date
Msg-id CAHyXU0w9nYm-PtDQKO3B4XUxU9ZvHeQdK3PDMLH_N31epE-Fbg@mail.gmail.com
Whole thread Raw
In response to Re: elegant and effective way for running jobs inside a database  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: elegant and effective way for running jobs inside a database  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
On Tue, Mar 6, 2012 at 4:01 PM, Alvaro Herrera
<alvherre@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).

Because that can't be done in userland (at least, not without stored
procedures) since you'd have to keep an open running transaction while
sleeping.

merlin


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: elegant and effective way for running jobs inside a database
Next
From: Alvaro Herrera
Date:
Subject: Re: elegant and effective way for running jobs inside a database