Re: More efficient build farm animal wakeup?

On 2022-11-23 We 16:59, Tom Lane wrote:
> Thomas Munro <thomas(dot)munro(at)gmail(dot)com> writes:
>> On Thu, Nov 24, 2022 at 10:00 AM Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>>> On Wed, Nov 23, 2022 at 9:15 AM Thomas Munro <thomas(dot)munro(at)gmail(dot)com> wrote:
>>> Are you saying you still think it's worth pursuing longpoll or similar methods for it, or that this is good enough?
>> I personally think it'd be pretty neat, to squeeze out that last bit
>> of latency. Maybe it's overkill...
> I can't get excited about pursuing the last ~30 seconds of delay
> for launching tasks that are going to run 10 or 20 or more minutes
> (where the future trend of those numbers is surely up not down).
>
> The thing that was really significantly relevant here IMO was to
> reduce the load on the central server, and I think we've done that.
> Would adding longpoll reduce that further? In principle maybe,
> but I'm not sure we have enough animals to make it worthwhile.
>
>

Yeah, that's my feeling. We have managed to get a large improvement with
a fairly small effort, I'm much less excited about getting another small
improvement from a large effort.

cheers

andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com