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

From Robert Haas
Subject Re: Reducing power consumption on idle servers
Date
Msg-id CA+TgmobHeqVxWusXjam1_GB89LD=vi4Q3AfL6P3Lf2ECTMb2PQ@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  (Simon Riggs <simon.riggs@enterprisedb.com>)
List pgsql-hackers
On Thu, Mar 24, 2022 at 12:02 PM Simon Riggs
<simon.riggs@enterprisedb.com> wrote:
> What about (1)? That directly affects the powersave capability. I
> didn't read anything specific to that.
>
> If we don't fix (1) as well, the changes for startup and walreceiver
> will be ineffective for powersaving.
>
> What changes will be acceptable for bgwriter, walwriter and logical worker?

Hmm, I think it would be fine to introduce some kind of hibernation
mechanism for logical workers. bgwriter and wal writer already have a
hibernation mechanism, so I'm not sure what your concern is there
exactly. In your initial email you said you weren't proposing changes
there, but maybe that changed somewhere in the course of the
subsequent discussion. If you could catch me up on your present
thinking that would be helpful.

Thanks,

-- 
Robert Haas
EDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Dilip Kumar
Date:
Subject: Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints
Next
From: Tom Lane
Date:
Subject: Re: Documenting when to retry on serialization failure