pgsql: Disable STARTUP_PROGRESS_TIMEOUT in standby mode.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Disable STARTUP_PROGRESS_TIMEOUT in standby mode.
Date: 2023-02-06 16:01:35
Message-ID: E1pP3vy-001tXG-Fv@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Disable STARTUP_PROGRESS_TIMEOUT in standby mode.

In standby mode, we don't actually report progress of recovery,
but up until now, startup_progress_timeout_handler() nevertheless
got called every log_startup_progress_interval seconds. That's
an unnecessary expense, so avoid it.

Report by Thomas Munro. Patch by Bharath Rupireddy, reviewed by
Simon Riggs, Thomas Munro, and me. Back-patch to v15, where
the problem was introduced.

Discussion: https://www.postgresql.org/message-id/CA%2BhUKGKCHSffAj8zZJKJvNX7ygnQFxVD6wm1d-2j3fVw%2BMafPQ%40mail.gmail.com

Branch
------
REL_15_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/98e7234242a652497c99d4d0d6f2bf9a75d4e921

Modified Files
--------------
src/backend/access/transam/xlogrecovery.c | 25 ++++++++++++++++++++++---
src/backend/postmaster/startup.c | 30 +++++++++++++++++++++++++++---
src/include/postmaster/startup.h | 2 ++
3 files changed, 51 insertions(+), 6 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2023-02-06 16:21:47 pgsql: Revert "Disable STARTUP_PROGRESS_TIMEOUT in standby mode."
Previous Message Peter Eisentraut 2023-02-06 13:03:01 pgsql: doc: Fix description of SQL standard parts