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

From Simon Riggs
Subject Re: Reducing power consumption on idle servers
Date
Msg-id CANbhV-GcWjZ2cmj0uCbZDWQUHnneMi_4EfY3dVWq0-yD5o7Ccg@mail.gmail.com
Whole thread Raw
In response to Re: Reducing power consumption on idle servers  (Thomas Munro <thomas.munro@gmail.com>)
Responses Re: Reducing power consumption on idle servers
List pgsql-hackers
On Sun, 13 Nov 2022 at 21:28, Thomas Munro <thomas.munro@gmail.com> wrote:
>
> On Mon, Nov 14, 2022 at 5:52 AM Simon Riggs
> <simon.riggs@enterprisedb.com> wrote:
> > The attached patch is a reduced version of the original. It covers only:
> > * deprecation of the promote_trigger_file - there are no tests that
> > use that, hence why there is no test coverage for the patch
> > * changing the sleep time of the startup process to 60s
> > * docs and comments
>
> LPGTM.  If we also fix the bogus SIGALRM wakeups[1], then finally a
> completely idle recovery process looks like:
>
> kevent(8,0x0,0,{ },1,{ 60.000000000 })           = 0 (0x0)
> kevent(8,0x0,0,{ },1,{ 60.000000000 })           = 0 (0x0)
> kevent(8,0x0,0,{ },1,{ 60.000000000 })           = 0 (0x0)
>
> Presumably it would have no timeout at all in the next release.
>
> [1] https://www.postgresql.org/message-id/CALj2ACUiYn+ZmPGUVmGeoY1u7ino2qsvqrnufk8sWPvK3A8yJA@mail.gmail.com

Clearly, I haven't been watching Hackers! Thanks for the nudge.

See if this does the trick?

-- 
Simon Riggs                http://www.EnterpriseDB.com/

Attachment

pgsql-hackers by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: Suppressing useless wakeups in walreceiver
Next
From: Thomas Munro
Date:
Subject: Re: Suppressing useless wakeups in walreceiver