Re: Reducing power consumption on idle servers

Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>

From: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>

To: Thomas Munro <thomas.munro@gmail.com>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, 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>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>

Date: 2023-01-31T09:23:25Z

Lists: pgsql-hackers

Attachments

v1-0001-Reduce-power-consumption-by-WAL-writer.patch (application/octet-stream) patch v1-0001

On Fri, Jan 27, 2023 at 12:41 PM Thomas Munro <thomas.munro@gmail.com> wrote:
>
> There's also the walwriter to look into; from memory it was a little
> less fuzzy but I haven't looked recently.

Thanks. I tried to do away with the walwriter hibernation for just
some time and made it wait indefinitely until an event occurs. Once
walwriter finds no work for some time, it goes to wait forever mode
and it's woken up when someone inserts WAL. Please see the attached
patch for more details. Thoughts?

-- 
Bharath Rupireddy
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com

Commits

Remove promote_trigger_file.
- cd4329d9393f 16.0 landed
Add pg_promote function
- 10074651e335 12.0 cited
pg_ctl promote
- 4695da5ae97b 9.1.0 cited