Re: pgAgent Windows service startup time

From: "Dmitry Samokhin" <sdld(at)mail(dot)ru>
To: pgadmin-support(at)postgresql(dot)org
Subject: Re: pgAgent Windows service startup time
Date: 2009-09-18 14:40:57
Message-ID: h9065g$veb$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2009-09-18 14:56:59 Re: Edit grid crash on Linux: adjusting selection (corrected)
Previous Message Dave Page 2009-09-18 13:22:40 Re: pgAgent Windows service startup time