Re: Reducing power consumption on idle servers

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Re: Reducing power consumption on idle servers
Дата
Msg-id CA+hUKG+HKzCTa=Wotud0yLq52qj3D9qFMQrPM5bM-WVkNNioPw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Reducing power consumption on idle servers  (Simon Riggs <simon.riggs@enterprisedb.com>)
Ответы Re: Reducing power consumption on idle servers  (Simon Riggs <simon.riggs@enterprisedb.com>)
Список pgsql-hackers
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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: WIP: Aggregation push-down - take2
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Suppressing useless wakeups in walreceiver