Re: pgAgent Windows service startup time - Mailing list pgadmin-support

From Dmitry Samokhin
Subject Re: pgAgent Windows service startup time
Date
Msg-id h9065g$veb$1@news.hub.org
Whole thread Raw
In response to pgAgent Windows service startup time  ("Dmitry Samokhin" <sdld@mail.ru>)
List pgadmin-support
>> Generally, it's perfectly clear that we can get job execution delay up to
>> the poll interval time. A proposed improvement for the pgAgent that might 
>> be
>> taken into account in the future is to store last read schedules 
>> (relative
>> to the server's real time) locally. And then to connect to the server 
>> when
>> the time is about to come for the nearest next job to execute regardless 
>> of
>> the poll interval set.

>Not sure that's such a good idea. What happens if your next job is
>scheduled for next month, and you add one for next week?

My little fault in explanation, 'regardless of the poll interval set' means 
to poll next time not later anyway than when the current interval (by the 
'-t' setting) ends, but maybe earlier (according to the locally stored 
schedules).

Dmitry. 




pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: Edit grid crash on Linux: adjusting selection (corrected)
Next
From: stefan0n
Date:
Subject: [ERROR ] Unknown exception: bad allocation