Horton

Re: Reducing power consumption on idle servers

Nathan Bossart <nathandbossart@gmail.com>

View thread View on postgr.es
From: Nathan Bossart <nathandbossart@gmail.com>
To: Thomas Munro <thomas.munro@gmail.com>
Cc: Simon Riggs <simon.riggs@enterprisedb.com>, Robert Haas <robertmhaas@gmail.com>, Kyotaro Horiguchi <horikyota.ntt@gmail.com>, Andres Freund <andres@anarazel.de>, Zheng Li <zhengli10@gmail.com>, Jim Nasby <nasbyj@amazon.com>, Tom Lane <tgl@sss.pgh.pa.us>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2022-11-20T22:55:47Z
Lists: pgsql-hackers 
On Mon, Nov 21, 2022 at 10:31:15AM +1300, Thomas Munro wrote:
> On Mon, Nov 21, 2022 at 9:00 AM Simon Riggs
> <simon.riggs@enterprisedb.com> wrote:
>> As a 3rd patch, I will work on making logical workers hibernate.
> 
> Duelling patch warning: Nathan mentioned[1] that he's hacking on a
> patch for that, along the lines of the recent walreceiver change IIUC.

I coded something up last week, but, like the walreceiver patch, it caused
check-world to take much longer [0], and I haven't looked into whether it
could be easily fixed.  I'm hoping to make some time for this again in the
near future.

[0] https://postgr.es/m/20221113222644.GA1269110%40nathanxps13

-- 
Nathan Bossart
Amazon Web Services: https://aws.amazon.com

Commits

  1. Remove promote_trigger_file.

  2. Add pg_promote function

  3. pg_ctl promote