Horton

Re: Reducing power consumption on idle servers

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jim Nasby <nasbyj@amazon.com>
Cc: Simon Riggs <simon.riggs@enterprisedb.com>, Andres Freund <andres@anarazel.de>, Thomas Munro <thomas.munro@gmail.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2022-03-03T22:49:28Z
Lists: pgsql-hackers 
Jim Nasby <nasbyj@amazon.com> writes:
> I'm wondering if it'd be worth linking autovac wakeup from a truly idle 
> state to the stats collector. If there's no stats messages coming in 
> clearly there's nothing new for autovac.

That seems pretty scary in the current system design, where the
stats collector is intentionally not 100% reliable (and sometimes,
less intentionally, it fails completely).  If we get to a place
where we're willing to bank on stats being collected 100% of the
time, it might make sense.

			regards, tom lane

Commits

  1. Remove promote_trigger_file.

  2. Add pg_promote function

  3. pg_ctl promote