Re: Reducing power consumption on idle servers - Mailing list pgsql-hackers

From Thomas Munro
Subject Re: Reducing power consumption on idle servers
Date
Msg-id CA+hUKGJCbcv8AtujLw3kEO2wRB7Ffzo1fmwaGG-tQLuMOjf6qQ@mail.gmail.com
Whole thread Raw
In response to Re: Reducing power consumption on idle servers  (Simon Riggs <simon.riggs@enterprisedb.com>)
Responses Re: Reducing power consumption on idle servers
List pgsql-hackers
On Wed, Nov 30, 2022 at 1:32 AM Simon Riggs
<simon.riggs@enterprisedb.com> wrote:
> Re-attaching patch for bgwriter and walwriter, so it is clear this is
> not yet committed.

I'm just curious, and not suggesting that 60s wakeups are a problem
for the polar ice caps, but why even time out at all?  Are the latch
protocols involved not reliable enough?  At a guess from a quick
glance, the walwriter's is but maybe the bgwriter could miss a wakeup
as it races against StrategyGetBuffer(), which means you might stay
asleep until the *next* buffer allocation, but that's already true I
think, and a 60s timeout is not much of a defence.



pgsql-hackers by date:

Previous
From: "Fujii.Yuki@df.MitsubishiElectric.co.jp"
Date:
Subject: RE: Partial aggregates pushdown
Next
From: Nathan Bossart
Date:
Subject: Re: O(n) tasks cause lengthy startups and checkpoints